IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Query on UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY ?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
www.ibmmainframes.com/about31098.html
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Tue Nov 25, 2008 3:44 am
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

Superior Member


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

PostPosted: Tue Nov 25, 2008 3:44 am
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: 72
Location: US

PostPosted: Tue Nov 25, 2008 12:53 pm
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: 1020
Location: India

PostPosted: Tue Nov 25, 2008 1:06 pm
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: 58
Location: home

PostPosted: Tue Nov 25, 2008 1:16 pm
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
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: 193
Location: chennai

PostPosted: Wed Nov 26, 2008 12:32 am
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: 1020
Location: India

PostPosted: Wed Nov 26, 2008 10:35 am
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
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
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
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

Superior Member


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

PostPosted: Thu Nov 27, 2008 2:13 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts How to load to DB2 with column level ... DB2 6
No new posts RC query -Time column CA Products 3
No new posts REASON 00D70014 in load utility DB2 6
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top