|
View previous topic :: View next topic
|
| Author |
Message |
divyabharathi
New User
Joined: 27 Aug 2014
Posts: 5
Location: India
|
|
|
|
Hi
I am connecting to db2 using the below code.Please see the attachment. But i am not able to free the allocated file. I am getting the error message as 'FILE DSNLOAD5 NOT UNALLOCATED, DATA SET IS OPEN' |
|
| Back to top |
|
 |
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| Please use copy/paste instead of attaching. |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
I concur with what Terry said. Attachments should not be used as they may be harmful, people may not be authorised to download them or people simply will not touch a post with an attachment - the OP makes it more difficult to understand the problem so why should someone help?
Anyway, good for you getting an error message. Waht do you not understand about it? Is it your dataset that is allocated to that DD or someone else's? If yours, is it part of a concatenation? |
|
| Back to top |
|
|
divyabharathi
New User
Joined: 27 Aug 2014
Posts: 5
Location: India
|
|
|
|
I could not paste the screen shot hence I attached. I understood that the file whcich i allocated was not free'ed properly hence i used the belwo code to free it. But here also I am getting error message as 'FILE DSNLOAD5 NOT FREED, DATA SET IS OPEN '
ADDRESS ISPEXEC "LIBDEF ISPLLIB"
ADDRESS TSO "FREE FI(DSNLOAD5)" |
|
| Back to top |
|
|
divyabharathi
New User
Joined: 27 Aug 2014
Posts: 5
Location: India
|
|
|
|
| The file(DBT3.SDSNLOAD) which i am allocating is not mine, it is DSNLOAD library of my test DB2 region. |
|
| Back to top |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006
Posts: 2547
Location: Silicon Valley
|
|
|
|
| What is DSNLOAD5 used for? I think your program opened the file, but did not close it. |
|
| Back to top |
|
|
divyabharathi
New User
Joined: 27 Aug 2014
Posts: 5
Location: India
|
|
|
|
| Dsnload5 is ddname for db2load lib. I am trying allocate dsnload5 to get connected with db2. Please see my attachment in my first post. If you are not able to see the attachment. Please reply me i will give you the screen shot. |
|
| Back to top |
|
|
divyabharathi
New User
Joined: 27 Aug 2014
Posts: 5
Location: India
|
|
|
|
Hi pedro
i have not opened the file. I am just allocating the file and trying to free it. |
|
| Back to top |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006
Posts: 2547
Location: Silicon Valley
|
|
|
|
Did you look at your PDF file before attaching it here?
You are making it too hard for people to help you.
1. instead of a true screen 'image' that will appear here as a jpeg, you need to use the mouse to drag over the screen text, the use Ctrl/C to copy to the clipboard as text. Paste that to this forum using
tags.
2. You are only showing bits and pieces of your exec. Show the whole thing.
3. Add TRACE('R') and show us the trace. In particular, what are all of the return codes from all of the statement prior to the FREE? |
|
| Back to top |
|
|
mjadwani2785
New User
Joined: 28 Apr 2009
Posts: 89
Location: Noida , Dublin
|
|
|
|
A code with trace can help both you and us .
Regards,
MJ |
|
| Back to top |
|
|
|
|
