Load Utility

Giridhar

unread,

Mar 31, 2004, 3:12:59 AM3/31/04

to

Hi,

I am using Load utility to load data ino a table.

I get following message
BPA0003E: DATASET OPEN FAILED FOR DDNAME: SYSPRINT.
BPA0044W: UNABLE TO DEALLOCATE DDNAME: SYSPRINT - RETURN CODE 0000438.
IKJ56247I FILE SYSPRINT NOT UNALLOCATED, IS NOT ALLOCATED

Can some one pl. suggest how do I come out of this problem?

Thanks & Regards
Giridhar

Kim Bundgaard

unread,

Mar 31, 2004, 3:18:12 AM3/31/04

to

Insert a line with

//SYSPRINT DD SYSOUT=*

in your jcl.

/Kim

"Giridhar" <gkgir...@indiatimes.com> wrote in message
news:9ad452d0.0403...@posting.google.com...

PM (pm3iinc-nospam)

unread,

Mar 31, 2004, 10:47:11 PM3/31/04

to

IKJ message makes me believe it has to do with the tso session allocation.
(tso listalc, tso allocate, if i remember correctly)
You can take a look at
tso help allocate

PM

"Kim Bundgaard" <kib at kmd.dk> a écrit dans le message de
news:406a7ec4$0$300$edfa...@dread12.news.tele.dk...

Giridhar

unread,

Apr 1, 2004, 12:35:25 AM4/1/04

to

Thanks for the reply.
I tried adding SYSPRINT but still I have got problem. I got following
messages after modifying JCL.

PREVIOUS RUN OF THIS INPUT ENDED WHILE PROCESSING A DB2
UTILITY. DB2 UTILITY-ID giri.sample MAY BE IN INCOMPLETE
STATUS.

I also got following message

BPA0002E: UNABLE TO DYNAMICALLY ALLOCATE FILE - RETURN CODE 0000410.
IKJ56246I FILE SYSPRINT NOT ALLOCATED, FILE IN USE
RETCODE = 8

I tried to terminate giri.sample through DB2 commands by executing
following command
-TERM UTILITY(giri.sample)
But I got a message saying there was no utility named giri.sample.
How can I solve this problem?

Thanks & Regards
Giridhar

"Kim Bundgaard" <kib at kmd.dk> wrote in message news:<406a7ec4$0$300$edfa...@dread12.news.tele.dk>...

PM (pm3iinc-nospam)

unread,

Apr 1, 2004, 10:09:31 AM4/1/04

to

File in use = you may need : tso free ...

http://www-1.ibm.com/servers/s390/os390/bkserv/lookat/lookat.html

What is BPA? bufferpool analyser, process manager?
Are you using ovms/BPX/USS BPXBATCH ?

BPA*
http://publibz.boulder.ibm.com/cgi-bin/zoslib/lookat.cmd?required=msgid&missing_fields_redirect=%2Fservers%2Fs390%2Fos390%2Fbkserv%2Flookat%2Flookatidmiss.html&msgid=BPA*&release=ZOS%2FV1R5

BPX / USS errors
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/DOCNUM/SA22-7807/CCONTENTS?

410 (for dynalloc)
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ikj3m130/6.319?ACTION=MATCHES&REQUEST=410&TYPE=EXACTW&SHELF=&DT=20000707161925&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

PM

@cgocable.ca PM (pm3iinc-nospam) CGO

unread,

Apr 6, 2004, 10:49:14 PM4/6/04

to

Mark A would know but i don't. (re: load terminate)

PM

tinoui

unread,

Jan 12, 2005, 10:06:22 AM1/12/05

to

I've experienced this problem.

The matter was that job had a B37 (too small dataset) a the same time.
when i soluced B37, error 00438 disapeared ...

i supposes that with B37 system try do open SYSPRINT to log some
informations but can't (allocation fail.....)