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
 

 

Reorg with sortkeys parameter error .

 
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 Dec 18, 2010 2:58 pm    Post subject: Reorg with sortkeys parameter error .
Reply with quote

Hi,
The following work data sets has been used in the reorg utility in order to rebuild it's index in parallel but in the near the end of the job I faced to the error.

Our DB2 version is 7 .


SW01WK01
.
.
.
SW01WK05

SW02WK01
.
.
.
SW02WK05

SW03WK01
.
.
.
SW03WK05

SW04WK01
.
.
.
SW04WK05

SORTWK01
.
.
.
SORTWK30

REORG TABLESPACE U3BANCS.TSINCT PART 69:87 LOG NO SORTDATA SORTKEYS
COPYDDN(SYSCOPY)

DSNU394I -DSN3 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=230546992 FOR INDEX U3BANCS.INCTUK_03

DSNU016I DSNUGSAT - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00C9'
DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347'

Please help me in this issue of you have any experience about this matter .

Regards
Manshadi
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Sat Dec 18, 2010 4:11 pm    Post subject: Reply to: Reorg with sortkeys parameter error .
Reply with quote

what happened when You looked at the manuals for the meaning of the

DSNU016 message

and the 00C9 00E40347 reason codes ?
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 IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am
No new posts Row not found Sql error GaganGarg DB2 7 Tue Mar 07, 2017 6:29 am


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