Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 6968
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: 6968
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 Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us