Hi, I am in a DB2 12 for z/OS environment with ZPARM PLANMGMT set to EXTENDED. Is there any combination of APREUSE & APCOMPARE options on a REBIND that will 'ignore' a rebind request (bypass rebind command with a warning automatically) if the ...
Hi I think I see your problem. You are running Db2 11 and not Db2 12. There was a change in behavior when reorging PBGs and I think that change was made in Db2 12. Please correct me someone if I am wrong. When you reorg a partition the data may grow ...
I was wrong. A reorg ran ok with the table whose max in use is 85%. Thank you,
We have a requirement to enable RACF passphrase. Are there changes within Db2 needed for that like in the communication database and sysibm.usernames? thanks Bill ------------------------------ williamgiannelliMe ----------------------------- ...
Hi James, I believe the total size you should consider with PBG tablespaces is DSSIZE * MAXPARTITIONS. So in your example you are not at 85% but less than 1/32 of the full size. The reorg wouldn't fail if 1 st partition fills, it simply defines ...