|
View previous topic :: View next topic
|
| Author |
Message |
itjagadesh
New User
Joined: 05 Dec 2006
Posts: 89
Location: chennai
|
|
|
|
Hi Team,
i am getting below error message while loading to DB2 tables
- UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY
UTILID = JJAY144, OBJECT = MFINVMAT.XINVREF0
When i am trying to use - DISPLAY UTIL(JJAY144) displaing below info
DSNU100I DSNT DSNUGDIS - USERID = DBAUSER
MEMBER = DST1
UTILID = JJAY144
PROCESSING UTILITY STATEMENT 1
UTILITY = LOAD
PHASE = ENFORCE COUNT = 1655397368
NUMBER OF OBJECTS IN LIST = 1
LAST OBJECT STARTED = 1
STATUS = STOPPED
Now i am not able to terminate or start the UTILID since it was submitted with USERID = DBAUSER.
1)can anyone please let me know how to resolve this?
2)what are all the possible reson for this error?
Thanks
Jagadesh |
|
| Back to top |
|
 |
Prasanthhere
Active User
Joined: 03 Aug 2005
Posts: 306
|
|
|
|
You have to terminate the Utitily JJAY144 which is running on objectMFINVMAT.XINVREF0
You have to terminate the utility first for further processing . You should have access to terminate the particular utility.
Try TU(JJAY144) if this command doesn't work you don't have access to terminate that.
Also check whether any load job is running already on the table which you are trying to load .
How about this link
www.ibmmainframes.com/about31098.html |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
Hi,
You should get some message of type - DSNUxxxx - DSNUxxxx - UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY, please post them. Use BBcode when you post them.
DB2 thinks that you have utility JJAY144 running on OBJECT =MFINVMAT.XINVREF0. Terminate the utility and try again. You might need to get in contact with your Support Group. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
Hi,
If possible can you please post your LOAD syntax. |
|
| Back to top |
|
|
ashok_uddaraju
New User
Joined: 21 Feb 2007
Posts: 72
Location: US
|
|
|
|
Hi,
If i am not wrong the UID which you might be using would be created dynamically when the job runs.
So in case you do not have access to terminate the UID the second option would be change the UID for the job and re-run he job |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Hi,
As ashok was saying,
| Quote: |
If i am not wrong the UID which you might be using would be created dynamically when the job runs.
So in case you do not have access to terminate the UID the second option would be change the UID for the job and re-run he job |
My question would be, How to change the UID ?
Sushanth |
|
| Back to top |
|
|
ruodeer
New User
Joined: 06 Jul 2007
Posts: 58
Location: home
|
|
|
|
when you use the Procedure, you can specify the UID as following:
| Code: |
| //STEP010 EXEC DSNUPROC,SYSTEM=DB8G,UID='utilityid' |
when you use the PGM=DSNUTILB directly, you can specify the UID in the second parm as following:
| Code: |
| //STEP010 EXEC PGM=DSNUTILB,PARM='DB8G,utilityid,' |
correct me if I am wrong. |
|
| Back to top |
|
|
itjagadesh
New User
Joined: 05 Dec 2006
Posts: 89
Location: chennai
|
|
|
|
Hi All,
Can anyone explain me
(So in case you do not have access to terminate the UID the second option would be change the UID for the job and re-run he job)
How to change the UID? (as sushant mentioned above)
Thanks
Jagadesh |
|
| Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008
Posts: 193
Location: chennai
|
|
|
|
Hi
As per the query posted, the utility is not terminated. It is only stopped at a phase called ENFORCE. ENFORCE is not the last phase of a LOAD utility. REPORT is the last phase. So the utility is still active. When a utility is started an entry will be made in the system directory table SYSIBM.SYSUTILX. This entry(UID) will be there in the directory until the utility is terminated. Not stopped. When the utility is terminated the entry from the directory table will get deleted automatically. So in this case since the utility is not terminated, either you can restart the utility with the same UID or you can terminate the utility by -term utility(UID) command or you can give a new UID for the job and rerun the same job.
Regards
Raghunathan |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Ruodeer,
As everyone were giving options like,
*) either you can restart the utility with the same UID
*) you can terminate the utility by -term utility(UID) command
*) you can give a new UID for the job and rerun the same job.
What ? I was wondering is "HOW to GIVE a NEW UID ? "
| Quote: |
when you use the Procedure, you can specify the UID as following:
//STEP010 EXEC DSNUPROC,SYSTEM=DB8G,UID='utilityid' |
| Quote: |
when you use the PGM=DSNUTILB directly, you can specify the UID in the second parm as following:
//STEP010 EXEC PGM=DSNUTILB,PARM='DB8G,utilityid,' |
By the method you specified, we can give our own Utility ID, right ?
And one more thing i want to know is, by giving our own utility ID, can we give any name to the UTILITY ID, like.. doesn't it have any naming conventions(this can ofcourse shop-dependent) that we have to follow OR can i give MY NAME as a utility id(i know that won't be a proper naming convention, i just want to know).
Sushanth |
|
| Back to top |
|
|
itjagadesh
New User
Joined: 05 Dec 2006
Posts: 89
Location: chennai
|
|
|
|
Hi Team,
Can anyone tell me
How to restart the utility with the same UID ?
(ie which command we need to use)
Thanks
Jagadesh |
|
| Back to top |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005
Posts: 306
|
|
|
|
| Your DBA team can easily terminate the UID , why don't you speak speak with the DBA support team regarding this issue |
|
| Back to top |
|
|
itjagadesh
New User
Joined: 05 Dec 2006
Posts: 89
Location: chennai
|
|
|
|
Thanks a lot to all of you participated.
Finally my DBA terminated the same UTILID .Now all of my table working fine.
Since That job submitted with USER =DBA
Thanks
Jagadesh |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
Hi Jagadesh,
Thanks for follow up & keeping us posted with the solution. Usually I was doing this
| Quote: |
| DBA terminated the same UTILID |
by calling them up.
However, this was for production JOBs but when this comes to "Test region" I've the liberty to do it my own.
Happy Thanksgiving..
-Ad |
|
| Back to top |
|
|
|
|
