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
 

 

Stored procedure calling a HP unload utility

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

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Wed Jul 15, 2009 4:42 pm    Post subject: Stored procedure calling a HP unload utility
Reply with quote

Hi,

I am trying to call a stored procedure through a program in a JCL which is
invoking a High Performance Unload utility. All the parametres passed though the program to the procedure and through the procedure to the Utility are correct. Whenevr i tried to execute this my job is abending wth the following error

S000 U1210 is the error that I am receiving.
IDI0001I Fault Analyzer V8R1M0 (UK41024 2008/10/27) invoked b
IDI0044I Current fault is a duplicate of fault ID F09167 in h
count is 2
IGD104I MVSP.FANALYZE.SIDIEXEC RETAINED, DDNAME=IDIEXEC
IEA995I SYMPTOM DUMP OUTPUT
USER COMPLETION CODE=1210
TIME=06.23.32 SEQ=64372 CPU=0000 ASID=0124
PSW AT TIME OF ERROR 078D1000 AA15AD20 ILC 2 INTC 0D
NO ACTIVE MODULE FOUND

I am unable to trace the probelm. Thanks in advance.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Wed Jul 15, 2009 4:48 pm    Post subject: Reply to: Stored procedure calling a HP unload utility
Reply with quote

please use a better terminology...
stored procedure ?? what do You mean,
never heard of invoking utilities thru stored procedures icon_eek.gif

anyway what happened when You searched the HP manuals for the meaning of the U1210 abend ???
Back to top
View user's profile Send private message
nagesh54

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Wed Jul 15, 2009 4:58 pm    Post subject:
Reply with quote

Hi,
I am really sorry. It is not a stored procedure. It is a JCL Procedure.
I didnt get any information about the error U1210.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Wed Jul 15, 2009 5:12 pm    Post subject: Reply to: Stored procedure calling a HP unload utility
Reply with quote

it is not overly complicated to find out
look at the messages timestamps
( the time was mostly due to cut and paste operations between the different browser tabs)
( and checking the post for errors in the links )

start from
http://www-03.ibm.com/systems/z/os/zos/bkserv/index.html#other_pubs
z/OS software products (Book)

proceed to
http://www-03.ibm.com/systems/z/os/zos/bkserv/zapplsbooks.html
z/OS software products: A - DB2 UDB bookshelf - 370 books
(List all bookshelves)

and to
http://www-03.ibm.com/systems/z/os/zos/bkserv/zappls1.html
DB2 Tools, April 2009 - 38 books
(List books)

and to
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/DM1SH00I
(DB2 High Performance Unload for z/OS V3R1 User's Guide)

and to
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/INZUGC12/CCONTENTS?SHELF=DM1SH00I&DN=SC19-1095-02&DT=20090429132010
(User abend codes)

and eventually
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/INZUGC12/7.1.1?SHELF=DM1SH00I&DT=20090429132010

see also
http://www-01.ibm.com/support/docview.wss?rs=434&context=SSZJXP&q=&uid=swg1PK40400&loc=en_US&cs=utf-8&lang=en+en
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Fri Jul 17, 2009 7:26 am    Post subject:
Reply with quote

There is an IBM supplied stored proc thru which utilities can be called. But I guess this is not what he is talking about. In any case, it is for DB2 utility, not HPUnload.
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
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am


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