Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Mismatching table & index CARDF after online index reorg

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Manshadi

New User


Joined: 31 Aug 2005
Posts: 82

PostPosted: Sat Aug 21, 2010 12:39 pm    Post subject: Mismatching table & index CARDF after online index reorg
Reply with quote

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
Back to top
View user's profile Send private message

Manshadi

New User


Joined: 31 Aug 2005
Posts: 82

PostPosted: Sat Aug 21, 2010 12:40 pm    Post subject:
Reply with quote

Do you have any idea about this matter?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Aug 21, 2010 1:38 pm    Post subject:
Reply with quote

Manshadi wrote:
Do you have any idea about this matter?


sounds as if you have an occasional problem.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Aug 21, 2010 2:46 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Manshadi

New User


Joined: 31 Aug 2005
Posts: 82

PostPosted: Sun Aug 22, 2010 12:11 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 1 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us