View previous topic :: View next topic |
Author |
Message |
rakshith Beginner
Joined: 26 Jul 2005 Posts: 32 Topics: 16 Location: bangalore
|
Posted: Fri Jan 06, 2006 2:09 am Post subject: VSAM Error code 168 |
|
|
HI all ,
I am getting this error code while loading the VSAM dataset from a flat file, please any one help me in this regard
IDCAMS SYSTEM SERVICES T
REPRO IFILE(IN) OFILE(OUT)
IDC3300I ERROR OPENING test.VSAM.file
IDC3351I ** VSAM OPEN RETURN CODE IS 168
IDC0005I NUMBER OF RECORDS PROCESSED WAS 0
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12
IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 12
thanks
rakshith |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12357 Topics: 75 Location: San Jose
|
Posted: Fri Jan 06, 2006 4:12 am Post subject: |
|
|
rakshith,
Check this link for an explanation as to why the you got that error.
http://www.mvsforums.com/helpboards/viewtopic.php?p=11349#11349
Run the following step to overcome that error.
Code: |
//STEP0100 EXEC PGM=SORT,PARM='VSAMEMT=YES'
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=YOUR VSAM FILE,
// DISP=SHR
//SORTOUT DD DSN=YOUR OUTPUT FLAT FILE,
// DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(TRK,(1,1),RLSE)
//SYSIN DD *
SORT FIELDS=COPY
/*
|
Hope this helps...
Cheers
Kolusu _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
rakshith Beginner
Joined: 26 Jul 2005 Posts: 32 Topics: 16 Location: bangalore
|
Posted: Fri Jan 06, 2006 5:27 am Post subject: |
|
|
Thank you kolusu for your quick response,
When I tried to use the above JCL, I am getting message like Dataset is in use
why is it so,
how can find out which job or anyone is using this dataset ?
please help me in this regard
Thanks
rakshith |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12357 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
rakshith Beginner
Joined: 26 Jul 2005 Posts: 32 Topics: 16 Location: bangalore
|
Posted: Fri Jan 06, 2006 11:32 am Post subject: |
|
|
Since we donot have TSO WHOHAS and it is VSAM file I could not find the user who is using.
i want to know how to release this file using some commands. plz help me
thanks
rakshith |
|
Back to top |
|
|
MikeBaker Beginner
Joined: 04 May 2004 Posts: 96 Topics: 9
|
Posted: Sat Jan 07, 2006 7:10 pm Post subject: |
|
|
Is there not even a single individual who works at your company who would know how to check who's using the file?? Your reply to Kolusu indicates that you have not tried all of the options which have been given to you, and that you are also jumping to mistaken conclusions. Carry out the instructions that you have been given. |
|
Back to top |
|
|
yadav2005 Intermediate
Joined: 10 Jan 2005 Posts: 348 Topics: 144
|
Posted: Tue Sep 25, 2007 6:01 am Post subject: |
|
|
Kolusu,
Your code :
Code: |
Run the following step to overcome that error.
Code:
//STEP0100 EXEC PGM=SORT,PARM='VSAMEMT=YES'
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=YOUR VSAM FILE,
// DISP=SHR
//SORTOUT DD DSN=YOUR OUTPUT FLAT FILE,
// DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(TRK,(1,1),RLSE)
//SYSIN DD *
SORT FIELDS=COPY
/*
|
SORTIN should be a flat file and SORTOUT should be VSAM DATASET that is how we are loading records to the VSAM , please correct me if i am wrong. |
|
Back to top |
|
|
|
|