Tag Info

Hot answers tagged

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 ...


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 ...


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

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.


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.



Only top voted, non community-wiki answers of a minimum length are eligible