MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Error while loading the DB2 table because of Utility

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
prasad_kdd
Beginner


Joined: 22 Aug 2005
Posts: 6
Topics: 4
Location: hyderabad
PostPosted: Fri Mar 06, 2009 12:31 am    Post subject: Error while loading the DB2 table because of Utility Reply with quote
Hi ALL,
Good Morning. We have a monthly batch run and they run first five days of the month. we have some db2 load jobs which will load the data into partition tables every month.usually when a job abends we get a Trouble ticket raised and we need to solve the Ticket.

we have many number of jobs that will load different tables. we use the utility DSNUTILB to load the tables with the help of a job. Now my Problem is sometimes when a job abends we get error message like shown below



Code:

DSNU180I  -D1IB DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE RUNSTATS TABLESPAC
                        UTILID = ZVWX3150.RUNSTAT, OBJECT = Database.SWXT30OD     
DSNU180I  -D1IB DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE RUNSTATS TABLESPAC
                        UTILID = ZVWX3150.RUNSTAT, OBJECT = Database.XWXBOPK3     
DSNU180I  -D1IB DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE RUNSTATS TABLESPAC
                        UTILID = ZVWX3150.RUNSTAT, OBJECT = Database.XWXB1IDI     
DSNU180I  -D1IB DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE RUNSTATS TABLESPAC
                        UTILID = ZVWX3150.RUNSTAT, OBJECT =Database.XWXB1JNJ     
DSNU180I  -D1IB DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE RUNSTATS TABLESPAC
                        UTILID = ZVWX3150.RUNSTAT, OBJECT = Database.XWXB1NWK     
DSNU180I  -D1IB DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE RUNSTATS TABLESPAC
                        UTILID = ZVWX3150.RUNSTAT, OBJECT =Database.XWXB168L     
DSNU180I  -D1IB DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE RUNSTATS TABLESPAC
                        UTILID = ZVWX3150.RUNSTAT, OBJECT = Database.XWXB1STM     
DSNU012I    DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8     


so the job abends and we get a Trouble Ticket raised every month. we will Terminate the Utility and we will rerun the abended job and it runs succesfully. Now my question is what do we need to do to avoid such type of utility errors occuring everymonth. Please suggest me a solution to avoid these type of problems which occur repeatedly.
_________________
prasad.Polisetti
Back to top
View user's profile Send private message
jsharon1248
Intermediate


Joined: 08 Aug 2007
Posts: 291
Topics: 2
Location: Chicago
PostPosted: Fri Mar 06, 2009 8:51 am    Post subject: Reply with quote
One of 2 choices. The first is modify your job schedule to prevent the LOAD job from running while the RUNSTATS job is running. The second option is to change the RUNSTATS SHRLEVEL option to CHANGE. The default is REFERENCE which only allows read-only access to the tablespace. CHANGE will permit update activity.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group