Tag Info

New answers tagged

3

According to the link that @mustaccio put in the comments: The database manager resets to S0000000.LOG if: A database configuration file is changed to enable rollforward recovery A database configuration file is changed to disable rollforward recovery S9999999.LOG has been used.


1

As I understand it, your development team got the error when using DbVisualizer with JTOpen (jt400.jar) for direct connections to the database. I got the same exception with DBvis ver 9.1.10. The tool took a long time when clicking the connect button, then finally showed error code -99999. What I do to fix this is to disable the Proxy setting of DBvis: ...


0

By default an online backup places the logs necessary to rollforward to the point of the end of the backup inside of the backup file. You can extract the logs from the backup file and then ROLLFORWARD to the end of them. Use the LOGTARGET clause of the RESTORE command to extract the logs to a location (I have tended to restore them to a location other than ...


2

It is relatively complicated to do, but it's possible. If your database has only DMS tablespaces that contain table data, you can use db2ckbkp -T <backup_file> alone to get this information: SYSCATSPACE tbspInImage: T ID: 0 flags: 7102 flags2: 400 ...


0

If you are using a SQL editor like Toad, this script may help as well. You can copy/paste the results in a new window. SELECT DISTINCT 'GRANT Select ON TABLE ' || rtrim (tabschema) || '.' || rtrim (tabname) || ' TO USER USERNAME;' FROM syscat.tables WHERE tabschema = 'Schema' UNION SELECT 'GRANT Select ON VIEW ' || rtrim ...


3

I wrote to the author, but I never received an answer. It seems the most recent version is for v9.7. The book can be obtained from db2hub or from the wayback machine. Anyway, I published all of them in my Google Drive: 7.2 https://drive.google.com/file/d/0B86nuTd5nMTKZzQtaTVTLUZ5ckE/edit?usp=docslist_api 8.2 ...


1

I found a way to do this using two batch files: test1.bat ------------------------------------------------------------------------ db2cmd -c -i -w "test2.bat" PAUSE test2.bat ------------------------------------------------------------------------ set db2instance=INST1 db2pd -db MYDB -hadr This is effectively the same as running in interactive mode but ...


1

You need to use the explain facilities in DB2 to answer this question, it's highly specific to the actual queries you are executing, and you can't get a general answer. IBM i 7.2 (and previous versions) have Visual Explain. If you are restricted from doing this, then you need to speak to the system or database administrator for your environment.


0

You can create a trigger on insert, delete or update on the table that will raise asignal automatically for these operations. This will make the tBle as read only and the security remain the same


2

Column-organized tables do not support some features, including identity columns. Apparently, in your database the default table organization (the DFT_TABLE_ORG parameter) is set to columns. Either change that or create the row-organized table explicitly: CREATE TABLE users ( user_id INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1), ...


1

There are a couple of ways to test it: Use LOCK TABLE and put it in "exclusive" mode REVOKE the privilege to INSERT or UPDATE on that table from the test user REVOKE the privilege to connect to that database Change or remove TCP/IP access to the database ... There are many testing scenarios and most of them will result in a different error message.



Top 50 recent answers are included