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 

Error in loading VSAM
Goto page 1, 2  Next
 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
mrinalsolanki
Beginner


Joined: 02 May 2006
Posts: 56
Topics: 16

PostPosted: Tue Sep 04, 2007 7:44 am    Post subject: Error in loading VSAM Reply with quote

Hi all,

I got return code of 12 while uploading data in VSAM.
JCL is as follows:

Code:
//STEP010  EXEC PGM=IDCAMS                                       
//IN   DD  DSN=PRAC.FILE,DISP=SHR                         
//OUT  DD  DSN=TEST.VSAM2,DISP=SHR 
//SYSOUT   DD  SYSOUT=*                                         
//SYSPRINT DD  SYSOUT=*                                         
//SYSIN    DD  *                                                 
  REPRO INFILE(IN) OUTDATASET(OUT)                               
                                                                 
/*       


PRAC.FILE is PDS and JCL to build cluster is as follows:



Code:
//STEP010 EXEC PGM=IDCAMS                             
//SYSPRINT DD SYSOUT=*                               
//SYSOUT   DD SYSOUT=*                               
//SYSIN    DD *                                       
 DEFINE CLUSTER ( -                                   
 NAME(TEST.VSAM2)        -                     
               VOLUME(STGG18)      -                 
               UNIQUE -                               
               SHAREOPTIONS(3 3) -                   
               CYLINDERS(7 7)) -                     
             DATA ( -                                 
               NAME(TEST.VSAM2.DATA)         -
               KEYS (29 0) -                         
               RECORDSIZE(35 35) -                   
               CISZ(4096)) -                         
             INDEX ( -                               
               NAME(TEST.VSAM2.INDEX)        -
               NOIMBED NOREPLICATE) -                 
             CATALOG(DEVELOP)               
/*                                                   


please help me to get out of it.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


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

PostPosted: Tue Sep 04, 2007 8:11 am    Post subject: Reply with quote

Quote:

I got return code of 12 while uploading data in VSAM.

mrinalsolanki,

We need to see the sysout messages. Most probably I think the error is due to un-initialized cluster.

Check this link
http://www.mvsforums.com/helpboards/viewtopic.php?p=18108#18108

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
mrinalsolanki
Beginner


Joined: 02 May 2006
Posts: 56
Topics: 16

PostPosted: Tue Sep 04, 2007 8:20 am    Post subject: Reply with quote

Kolusu,

This is in sysprint

Code:
IDCAMS  SYSTEM SERVICES                                           TIM
                                                                     
  REPRO INFILE(IN) OUTDATASET(OUT)                                   
IKJ56228I DATA SET OUT NOT IN CATALOG OR CATALOG CAN NOT BE ACCESSED
IDC0005I NUMBER OF RECORDS PROCESSED WAS 0                           
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12                   
                                                                     
                                                                     
IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 12   
Back to top
View user's profile Send private message
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Tue Sep 04, 2007 8:44 am    Post subject: Reply with quote

Quote:

DATA SET OUT NOT IN CATALOG OR CATALOG CAN NOT BE ACCESSED

_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
expat
Intermediate


Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales

PostPosted: Wed Sep 05, 2007 12:41 pm    Post subject: Reply with quote

Have you tried OUTFILE instead of OUTDATASET bonk
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?
Back to top
View user's profile Send private message
mrinalsolanki
Beginner


Joined: 02 May 2006
Posts: 56
Topics: 16

PostPosted: Thu Sep 06, 2007 4:06 am    Post subject: Reply with quote

yeah ,

I got this error by using OUTFILE

Code:
IDCAMS  SYSTEM SERVICES                                           TIME: 05:04:06
                                                                               
  REPRO INFILE(IN) OUTFILE(OUT)                                         00260005
IDC3302I  ACTION ERROR ON TEST.VSAM1                                     
IDC3351I ** VSAM I/O RETURN CODE IS 108 - RPLFDBWD = X'8408006C'               
IDC31467I MAXIMUM ERROR LIMIT REACHED.                                         
IDC0005I NUMBER OF RECORDS PROCESSED WAS 0                                     
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12                             
                                                                               
                                                                        00270002
IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 12             
Back to top
View user's profile Send private message
CICS Guy
Intermediate


Joined: 30 Apr 2007
Posts: 292
Topics: 3

PostPosted: Thu Sep 06, 2007 4:38 am    Post subject: Reply with quote

Are you just waiting for someone to look the error up for you?
IDC3351I ** VSAM I/O RETURN CODE IS 108 - RPLFDBWD = X'8408006C'
Back to top
View user's profile Send private message
s_shivaraj
Beginner


Joined: 21 Sep 2004
Posts: 140
Topics: 14
Location: Chennai, India

PostPosted: Thu Sep 06, 2007 12:09 pm    Post subject: Reply with quote

Quote:
PRAC.FILE is PDS

Can we copy a PDS(all members) to a sequential file using IDCAMS ..
_________________
Cheers
Sivaraj S

'Technical Skill is the Master of complexity, while Creativity is the Master of Simplicity'
Back to top
View user's profile Send private message AIM Address
CICS Guy
Intermediate


Joined: 30 Apr 2007
Posts: 292
Topics: 3

PostPosted: Thu Sep 06, 2007 12:14 pm    Post subject: Reply with quote

s_shivaraj wrote:
Quote:
PRAC.FILE is PDS

Can we copy a PDS(all members) to a sequential file using IDCAMS ..
Huh?
Back to top
View user's profile Send private message
expat
Intermediate


Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales

PostPosted: Thu Sep 06, 2007 3:36 pm    Post subject: Reply with quote

s_shivaraj wrote:
Quote:
PRAC.FILE is PDS

Can we copy a PDS(all members) to a sequential file using IDCAMS ..


And just how does this relate in any way to the VSAM error being discussed ???

Please start a new thread for a new question.
Back to top
View user's profile Send private message
s_shivaraj
Beginner


Joined: 21 Sep 2004
Posts: 140
Topics: 14
Location: Chennai, India

PostPosted: Thu Sep 06, 2007 3:46 pm    Post subject: Reply with quote

expat,
Thats what mrinalsolanki, wants to achieve? .Uploading data from a PDS to a VSAM.. am i missing anything ..
_________________
Cheers
Sivaraj S

'Technical Skill is the Master of complexity, while Creativity is the Master of Simplicity'
Back to top
View user's profile Send private message AIM Address
CICS Guy
Intermediate


Joined: 30 Apr 2007
Posts: 292
Topics: 3

PostPosted: Thu Sep 06, 2007 4:07 pm    Post subject: Reply with quote

s_shivaraj wrote:
expat,
Thats what mrinalsolanki, wants to achieve? .Uploading data from a PDS to a VSAM.. am i missing anything ..
I'm sorry for being SO STUPID, but could you PLEASE point me to the where "Uploading data from a PDS" entered into this topic????? Confused Confused Rolling Eyes
Back to top
View user's profile Send private message
s_shivaraj
Beginner


Joined: 21 Sep 2004
Posts: 140
Topics: 14
Location: Chennai, India

PostPosted: Thu Sep 06, 2007 4:25 pm    Post subject: Reply with quote

Code:
//STEP010  EXEC PGM=IDCAMS                                       
//IN   DD  DSN=PRAC.FILE,DISP=SHR


Quote:
PRAC.FILE is PDS


These are the lines from the first message.. Am i wrong.. am i understood wrongly .. Question
_________________
Cheers
Sivaraj S

'Technical Skill is the Master of complexity, while Creativity is the Master of Simplicity'
Back to top
View user's profile Send private message AIM Address
CICS Guy
Intermediate


Joined: 30 Apr 2007
Posts: 292
Topics: 3

PostPosted: Thu Sep 06, 2007 4:48 pm    Post subject: Reply with quote

s_shivaraj wrote:
Code:
//STEP010  EXEC PGM=IDCAMS                                       
//IN   DD  DSN=PRAC.FILE,DISP=SHR


Quote:
PRAC.FILE is PDS


These are the lines from the first message.. Am i wrong.. am i understood wrongly .. Question
Thank you very much, I must had a small case of male vision.... Embarassed
Back to top
View user's profile Send private message
expat
Intermediate


Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales

PostPosted: Sat Sep 08, 2007 2:12 am    Post subject: Reply with quote

Me too Embarassed
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?
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
Goto page 1, 2  Next
Page 1 of 2

 
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