MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

VSAM Error code 168

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
rakshith
Beginner


Joined: 26 Jul 2005
Posts: 32
Topics: 16
Location: bangalore

PostPosted: Fri Jan 06, 2006 2:09 am    Post subject: VSAM Error code 168 Reply with quote

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
View user's profile Send private message Yahoo Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12357
Topics: 75
Location: San Jose

PostPosted: Fri Jan 06, 2006 4:12 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
rakshith
Beginner


Joined: 26 Jul 2005
Posts: 32
Topics: 16
Location: bangalore

PostPosted: Fri Jan 06, 2006 5:27 am    Post subject: Reply with quote

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
View user's profile Send private message Yahoo Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12357
Topics: 75
Location: San Jose

PostPosted: Fri Jan 06, 2006 5:34 am    Post subject: Reply with quote

Quote:

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 ?



rakshith,

Check this link

http://www.mvsforums.com/helpboards/viewtopic.php?p=6527#6527

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
View user's profile Send private message Send e-mail Visit poster's website
rakshith
Beginner


Joined: 26 Jul 2005
Posts: 32
Topics: 16
Location: bangalore

PostPosted: Fri Jan 06, 2006 11:32 am    Post subject: Reply with quote

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
View user's profile Send private message Yahoo Messenger
MikeBaker
Beginner


Joined: 04 May 2004
Posts: 96
Topics: 9

PostPosted: Sat Jan 07, 2006 7:10 pm    Post subject: Reply with quote

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
View user's profile Send private message
yadav2005
Intermediate


Joined: 10 Jan 2005
Posts: 348
Topics: 144

PostPosted: Tue Sep 25, 2007 6:01 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group