Mismatching table & index CARDF after online index reorg

Manshadi · New User Joined: 31 Aug 2005 Posts: 82

Hi,

We are using the following option for index online reorg :

REORG INDEX(dbame,.index)
SORTDEVT SYSDA SORTNUM 4
SHRLEVEL CHANGE

after running runstat utility we found that the number of records in table CARDF is mismatch with FULLKEYCARD of index.

It should be note that this problem happen occasionally.

The reorg job will completed successfully (RC=0) without any massage in output.

Thanks
Manshadi

Manshadi · New User Joined: 31 Aug 2005 Posts: 82

Do you have any idea about this matter?

dbzTHEdinosauer · Posted: Sat Aug 21, 2010 1:38 pm

dbzTHEdinosauer · Posted: Sat Aug 21, 2010 2:46 pm

obviously something is being dropped or missed.

i would start by insuring that the parms for the reorg accurately reflect the potential volume.

i would insure that the allocated resources for the job follow guidelines provided by ibm - or the author of your reorg utility.

have you contacted the support group of the firm that provided you with the reorg utility?

are there any other activities going on (with db2 and specifically the tables in question) during the reorg?

Though it sounded sarcastic, my previous post was actually very honest.
all you told us was that you occasionally have a problem.
no information.

Manshadi · New User Joined: 31 Aug 2005 Posts: 82

Hi,

The following is exactly the job which we are running for reorg index.

The table have 4 INDEXES and we are running reorg index for all of them in parallel in the same time.

Moreover the other table space and index is reorging during that time
depend on the available system resource.

We are also running runstat utility in some table spaces during that time.

//ROXTBL1P JOB (XXXXXX),'ROXX TBL1',
// REGION=0M,NOTIFY=&SYSUID,MSGLEVEL=(1,1),
// MSGCLASS=X,CLASS=A,TYPRUN=HOLD
//ROXUILD EXEC DSNUPROC,SYSTEM=DSNx,
// LIB='DSN710.DSNx.SDSNLOAD',UID='ROXTBL1P'
//SYSUT1 DD DSN=M&SYSUID..TBL1P.SYSUT1,
// VOL=(,,,50),STORCLAS=SCLARGE,
// SPACE=(CYL,(3000,1200),,,ROUND),UNIT=SYSDA
//SYSREC DD DSN=M&SYSUID..TBL1P.SYSREC,
// VOL=(,,,50),STORCLAS=SCLARGE,
// SPACE=(CYL,(3000,1200),,,ROUND),UNIT=SYSDA
//SORTOUT DD DSN=M&SYSUID..TBL1P.SORTOUT,
// VOL=(,,,50),STORCLAS=SCLARGE,
// SPACE=(CYL,(3000,1200),,,ROUND),UNIT=SYSDA
//SORTWK01 DD DISP=(MOD,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(3000,1500),RLSE),
// VOL=(,,,50),STORCLAS=SCLARGE
.
.
.
//SORTWK40 DD DISP=(MOD,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(3000,1500),RLSE),
// VOL=(,,,50),STORCLAS=SCLARGE

//DSNUPROC.SYSIN DD *
REORG INDEX(DBNAME.TBL1PK)
SORTDEVT SYSDA SORTNUM 4
SHRLEVEL CHANGE

Best regards
Manshadi