How can I get Recovery management for DB2 v11.2 when I see only 12.1 in the installation system? Do I need to fall back to a previous version of the installation system and if so how?
Log in to learn more about philguk, share content, and exchange messages and invites.
Cat Mgr plugging in logical partition number in create table statement instead of physical partition
Hi, First time user. Am using Cat Mgr V11.01.00 to generate DDL for a table that is using table controlled partitioning on db2 z/os V10. The DDL command is plugging in the "logical partition"… Show more
DB2 NGT "Manual says that CATCHUP_CYCLES is an upper limit of the processing of applying update data. Does it mean LOG APPLY of REORG? Is this parameter applicable only for NGT REORG and NGT LOAD… Show more
Has anyone faced Lock escalation on SYSCOLDIST_HIST and SYSCOLUMNS_HIST during REORG? Global Options are RUNSTATS(NO) and we are expecting REORG not to run RUNSTATS. But the REORG job caused lock escalation on these catalog tables.
Has anyone faced Lock escalation on SYSCOLDIST_HIST and SYSCOLUMNS_HIST during REORG? We have Global Options as RUNSTATS(NO) and we are expecting reorg NOT to run RUNSTATS. Cannot find any… Show more
Hi community members. We use NGT for Db2 V12.01. Some of our table spaces and indexes are defined with parameters PRIQTY -1 and SECQTY -1. Do NGT REORG and LOAD utilities automatically calculate… Show more
Hi community members. We use NGT for Db2 V12.01. Some of our tables are defined with parameter PCTFREE FOR UPDATE -1. Do NGT REORG and LOAD utilities use RTS to automatically calculate the… Show more