DB2

database in use
Hi! (db2 UDB V9.5.5 Linux RedHat 4) I want to drop a database before doing a restore into it from another database. db2 get db cfg: Database is consistent YES Rollforward pending NO Restore pending NO Automatic maintenance ON Deactivate database --> Success but database was not activate... 10 Jun 2010 15:39

DB2 V9.1 Hadr Delay Syncup
Hi I am working on Db2 V9.1 HADR Environment. I am looking for HADR Parameter which will help in delay in Syncronisation in between Primay and Standy databases by 2 Hrs. ... 9 Jun 2010 10:49

Incremental Restore question
db2 V9.5.5 on linux Red Hat 4 with 4 local Nodes (partitioned). Backups taken: Backup PRODDB (offline) --> Cold1 Backup PRODDB online incremental --> Hot1 Backup PRODDB online incremental --> Hot2 Backup PRODDB online incremental --> Hot3 Is this OK? Hot1 and Hot2 are not needed? On ea... 9 Jun 2010 11:56

canceling admin_move_table fails if source table have restricton drop
This is a bug and I asked the owner of the code to open an APAR. It will be fixed in the next fixpack. The only workaround for now is to drop the restrict on drop constraint and to recreate it afterwards. On 8.6.2010 02:31, hsn_ wrote: db2 => call sysproc.admin_move_table(current schema,'Z2','USERSPACE1',... 8 Jun 2010 14:50

canceling admin_move_table fails if source table have restrict on drop
db2 => create table z2 (a integer) in alexaidx DB20000I Pøíkaz SQL byl úspì¹nì dokonèen. db2 => alter table z2 add restrict on drop DB20000I Pøíkaz SQL byl úspì¹nì dokonèen. db2 => call sysproc.admin_move_table(current schema,'Z2','USERSPACE1','USERSPACE 1','USERSPACE1',NULL,NULL,NULL,NULL,NULL,'INIT') V... 8 Jun 2010 02:33

Password validation messages
We have a system at one of our customers where the db2diag.log file is filled with these messages (they always come together): 2010-06-04-21.11.30.788000+120 I2866F457 LEVEL: Warning PID : 8484 TID : 5272 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB... 11 Jun 2010 04:51

Question on DB2MON
How do I get that lock dependency hierarchy to show in db2mon? ... 4 Jun 2010 23:32

Transportable tablespaces in 9.7.2
I can not get them to work. It always fails in DDL Extract phase. Do i need to (re)bind some package? Error code is: SQL2590N Po¾adovanou operaci RESTORE nebylo mo¾né dokonèit, proto¾e do¹lo k chybì pøenosu schématu. Kód pøíèiny: "16". diag log is: 2010-06-04-16.21.19.718000+120 I415102H474 LEVEL: In... 9 Jun 2010 18:40

DB2 V10 and z800
The DB2 v10 announcement letter has a conflicting statement '.DB2 10 for z/OS operates on z10T, z9T, z990, z890, or higher, processors supported by z/OS V1.10, or later. The first part of the statement says z800 and z900 will not run DB2 V10. The second part states any processors supported by z/OS v1.10 or later. N... 4 Jun 2010 01:36

Spaceusage of LOBs
Hi, how much space is used by LOBs. I've the following scenario which I don't understand: We've a table with 8 columns with a regular data type and one BLOB- Column defined as "BLOBDATA" BLOB(104857600) LOGGED NOT COMPACT. The table is using a SMS-Tablespace. With the 'list tablespaces show detail' command... 8 Jun 2010 14:50