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
 

 

Query on UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
itjagadesh

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Mon Nov 24, 2008 4:22 pm    Post subject: Query on UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY ?
Reply with quote

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
View user's profile Send private message

Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Mon Nov 24, 2008 5:34 pm    Post subject:
Reply with quote

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
http://www.ibmmainframes.com/about31098.html
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Nov 25, 2008 3:44 am    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Nov 25, 2008 3:44 am    Post subject:
Reply with quote

Hi,

If possible can you please post your LOAD syntax.
Back to top
View user's profile Send private message
ashok_uddaraju

New User


Joined: 21 Feb 2007
Posts: 70
Location: bangalore

PostPosted: Tue Nov 25, 2008 12:53 pm    Post subject: Reply to: Query on UTILITY IS NOT COMPATIBLE WITH THE LOAD U
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Nov 25, 2008 1:06 pm    Post subject:
Reply with quote

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
View user's profile Send private message
ruodeer

New User


Joined: 06 Jul 2007
Posts: 59
Location: home

PostPosted: Tue Nov 25, 2008 1:16 pm    Post subject:
Reply with quote

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
View user's profile Send private message
itjagadesh

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Tue Nov 25, 2008 5:08 pm    Post subject: Reply to: Query on UTILITY IS NOT COMPATIBLE WITH THE LOAD U
Reply with quote

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
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Wed Nov 26, 2008 12:32 am    Post subject: Reply to: Query on UTILITY IS NOT COMPATIBLE WITH THE LOAD U
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Nov 26, 2008 10:35 am    Post subject:
Reply with quote

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
View user's profile Send private message
itjagadesh

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Wed Nov 26, 2008 11:36 am    Post subject: Reply to: Query on UTILITY IS NOT COMPATIBLE WITH THE LOAD U
Reply with quote

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
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Nov 26, 2008 12:06 pm    Post subject:
Reply with quote

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
View user's profile Send private message
itjagadesh

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Wed Nov 26, 2008 7:22 pm    Post subject: Reply to: Query on UTILITY IS NOT COMPATIBLE WITH THE LOAD U
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Nov 27, 2008 2:13 am    Post subject:
Reply with quote

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
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
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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