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 during DB2 load

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


Joined: 02 Sep 2005
Posts: 77
Topics: 10
Location: Cincinnati

PostPosted: Wed Jan 11, 2006 2:28 am    Post subject: Error during DB2 load Reply with quote

Hi
I am getting the following error message while loading the DB2 table using
PGM=XSNUTILB
Code:

PFL0033I - Region Size below is ...7,733,248 bytes                             
                                                                               
PUT0019I - Elapsed Time: 00:00:00                                               
PFL0053I - MVS Ver: 7.0.4 , DFSMS Ver: 1.03.0, DB2 Ver: 7.1                     
                                                                               
PFL0001I - FASTLOAD Version 07.01.4  DB2 SSID: D2T1 - Processing Started       
PFL0501I - Number of INPUT tasks to start:           1                         
PFL0502I - Number of SORT tasks to start:            1                         
PFL0503I - Maximum number of INPUT devices req:      1     DDNAME: SYSREC       
PFL0504I - Minimum number of OUTDDN devices req:     0     DDNAME: SYSULD       
PFL0505I - Maximum number of OUTDDN devices used:    0                         
PFL0506I - Minimum number of WORKDDN devices req:    0     DDNAME: SYSUT1       
PFL0507I - Maximum number of WORKDDN devices used:   0                         
PFL0032I - IO-BUFFERS set to : 050                                             
                                                                               
PFL0403E - Restart Table - Object XXXXMCD.XXXXRTH in use by another Utility   
           UTLIID AAAAAAS.AAAAAAH Checksum 22459                               
           Utility in Conflict: UTILID BBBBBBT.BBBBBBH Checksum 22459         
           Return Code: 00000008  Reason Code: 00000058                         
                                                                               
PFL0028I - FASTLOAD Processing ended - Return Code 008                         

On QW..
Code:

PFL0403E - Restart Table - Object in use by Utility &UTIL                     
Return Code: &RC Reason Code: &REAS                                           
                                                                             
   An object is already in use by the utility named in this message. Wait for
   other utility to complete and resubmit the job.                           



There is no jobs running under BBBBBB* id. Please throw some light on how to free the object

Please let me know if i need to paste the JCL.

Thanks,
Jaya.
_________________
"Great spirits have always encountered violent opposition from mediocre minds."
-Albert Einstein
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Wed Jan 11, 2006 5:03 am    Post subject: Reply with quote

Jaya,

Check this link for displaying the utilities and then terminating them.

http://mvsforums.com/helpboards/viewtopic.php?p=3067#3067

First run the Job with just the -DISPLAY statement and see the list of utilities running. Then upon verifying run the same JCL with -TERM UTILTIY statement.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Jaya
Beginner


Joined: 02 Sep 2005
Posts: 77
Topics: 10
Location: Cincinnati

PostPosted: Wed Jan 11, 2006 5:21 am    Post subject: Reply with quote

Thank you for the reply Kolusu...

Before making the post...

I had given

-DISPLAY UTIL(*) in DB2 commands

DSNU112I - DSNUGDIS - NO AUTHORIZED UTILITY FOUND FOR UTILID = *
DSN9022I - DSNUGCCC '-DISPLAY UTIL' NORMAL COMPLETION
***

I have no authorisation to view BBBBBB*.* utilities

Since we are using CA utility, i used the program PTLDRIVM
to terminate the Utility using the command
-TERM CA UTILITY(BBBBBBT.BBBBBBH)

The problem is now resolved Smile

Thanks again,
Jaya.
_________________
"Great spirits have always encountered violent opposition from mediocre minds."
-Albert Einstein
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