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

Facing Error while loading into DB2 tables


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prangya
Currently Banned

New User


Joined: 12 Jul 2008
Posts: 7
Location: pune

PostPosted: Wed Aug 13, 2008 1:11 pm
Reply with quote

Hi,

I'm trying to load into one DB2 table. But it's getting abended. Ichecked the status of table space. The status is CAS00008 TS STOPP,UTUT.

I tried to TERM UTILITY(utilityname) . I used tablespace name as utilty name.But getting this messages.
DSNU112I -DBA3 DSNUGDIS - NO AUTHORIZED UTILITY FOUND FOR UTILID =
CAS00008
DSN9022I -DBA3 DSNUGCCC '-TERM UTILITY' NORMAL COMPLETION


But not sure what could be utilty name. Please let me know from where'll i get the utility name.

If there is anyother approach to fix it please let me know.
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India

PostPosted: Wed Aug 13, 2008 1:25 pm
Reply with quote

Hi,

Please find the Utility ID on either load jcl (the STEP got abended) or SYSPRINT of that STEP(possibly).
Quote:
DSNU112I -DBA3 DSNUGDIS - NO AUTHORIZED UTILITY FOUND FOR UTILID =
CAS00008
DSN9022I -DBA3 DSNUGCCC '-TERM UTILITY' NORMAL COMPLETION

The reason might be..., The utilid might not be correct, or the utility might have already terminated.

To view all currently valid identifiers, issue the -DISPLAY UTILITY (*) or (partial-utility-id*) command.
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Aug 13, 2008 2:07 pm
Reply with quote

If you have platinum Utility in the shop try this

Type Command C once you enter PLA

after that give the command DU (Display Utility)

Then type this

-DISPLAY UTILITY (*)

This will display all the utilities running againist a particular region
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 Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Getting Error while trying to establi... DB2 3
Search our Forums:

Back to Top