View previous topic :: View next topic |
Author |
Message |
Jaya Beginner

Joined: 02 Sep 2005 Posts: 77 Topics: 10 Location: Cincinnati
|
Posted: Wed Jan 11, 2006 2:28 am Post subject: Error during DB2 load |
|
|
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 |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Wed Jan 11, 2006 5:03 am Post subject: |
|
|
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 |
|
 |
Jaya Beginner

Joined: 02 Sep 2005 Posts: 77 Topics: 10 Location: Cincinnati
|
Posted: Wed Jan 11, 2006 5:21 am Post subject: |
|
|
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
Thanks again,
Jaya. _________________ "Great spirits have always encountered violent opposition from mediocre minds."
-Albert Einstein |
|
Back to top |
|
 |
|
|