cannot open KSDS



Support for CICS/ESA, CICS/TS & Transaction Gateway, CICS Configuration Manager and CICS Performance Analyzer

cannot open KSDS

Postby cp_ur530 » Tue May 31, 2011 8:51 am

 
//P390AIX JOB ACCT#,'TRAINER',CLASS=A,NOTIFY=&SYSUID, 
//            MSGCLASS=X,MSGLEVEL=(1,1)               
//STEP1    EXEC PGM=IDCAMS                             
//SYSPRINT DD   SYSOUT=*                               
//SYSIN    DD   *                                     
LISTCAT ENT(P390.BOOK.KSDS) ALL                       
  DEFINE AIX (-                                         
              NAME ('P390.BOOK.KSDS.AIX') -             
              RELATE ('P390.BOOK.KSDS') -               
              VOLUME ( OS39M1 ) -                       
              RECORDS ( 100 20 ) -                     
              KEYS (41 12 ) -                           
              UPGRADE -                                 
              NONUNIQUEKEY -                           
              RECORDSIZE ( 58 99 ) -                   
             )                                         
  DEFINE PATH (-                                       
               NAME ('P390.BOOK.KSDS.PATH') -           
               PATHENTRY ('P390.BOOK.KSDS.AIX') -       
              )                                         
  BLDINDEX - 
             INDATASET ('P390.BOOK.KSDS') -     
             OUTDATASET ('P390.BOOK.KSDS.AIX')                                             


that's my jcl to create AIX ,and I'm sure that was successfully executed ...
'P390.BOOK.KSDS' has been defined as file(book) in cics ,when I want to open the file again ,I failed ,why?????
cp_ur530
 
Posts: 5
Joined: Wed Apr 20, 2011 6:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: cannot open KSDS

Postby dick scherrer » Tue May 31, 2011 9:17 am

Hello,

'P390.BOOK.KSDS' has been defined as file(book) in cics ,when I want to open the file again ,I failed ,why?????

What is a "file(book)" to you?. Again? Does this mean you successfully opened this file one time? How did you open this file?

that's my jcl to create AIX ,and I'm sure that was successfully executed ...

You need to post the outputs from all of the runs that were successful and the error that is happening when you try to open this file.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: cannot open KSDS

Postby cp_ur530 » Tue May 31, 2011 10:28 am

dick scherrer wrote:Hello,

What is a "file(book)" to you?. Again? Does this mean you successfully opened this file one time? How did you open this file? ...


ceda define file(book) dsname('p390.book.ksds') group(XXXX)
and I have used file(book) serval times in a transation to read and write records


You need to post the outputs from all of the runs that were successful and the error that is happening when you try to open this file

before I read file in transation ,I must set the file opened

and
before I create AIX on p390.book.ksds ,I must set it closed

but after I create an AIX ,I cannot set file(book) opened
cp_ur530
 
Posts: 5
Joined: Wed Apr 20, 2011 6:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: cannot open KSDS

Postby dick scherrer » Tue May 31, 2011 11:36 am

Hello,

but after I create an AIX ,I cannot set file(book) opened
Why not - what error prevents the open?

What happens if you combine the CREATEs into one run and then repro some data into the file?

It may help if you post the complete output from the IDCAMS.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: cannot open KSDS

Postby mongan » Tue May 31, 2011 12:10 pm

Did you define the path in CICS?

OBJECT CHARACTERISTICS CICS RELEASE = 0640
CEDA View File( V100TB1 )
File : V100TB1
Group : FCTT2
DEScription :
VSAM PARAMETERS
DSNAme : TBASLO.DBT2.V100TB1.PERM.PATH
Password : PASSWORD NOT SPECIFIED
RLsaccess : No Yes ! No
LSrpoolid : 1 1-8 ! None
READInteg : Uncommitted Uncommitted ! Consistent ! Repeatable
DSNSharing : Allreqs Allreqs ! Modifyreqs
STRings : 002 1-255
Nsrgroup :
REMOTE ATTRIBUTES
REMOTESystem :
REMOTEName :
REMOTE AND CFDATATABLE PARAMETERS
+ RECORDSize : 1-32767
User avatar
mongan
 
Posts: 211
Joined: Tue Jan 11, 2011 8:32 pm
Has thanked: 1 time
Been thanked: 5 times

Re: cannot open KSDS

Postby Robert Sample » Tue May 31, 2011 4:05 pm

Your subject "cannot open KSDS" is totally wrong and misleading. You cannot open the alternate index -- which is defined as a separate VSAM file and RELATEd to the base cluster. If you have not defined an entry in CEDA for the alternate index, you cannot use it in a CICS region -- just like for any other VSAM file.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: cannot open KSDS

Postby mongan » Wed Jun 01, 2011 11:46 am

Robert, not necessarily. When you try to open a KSDS that has an alternate index with upgrade then you have to have the definitions for the path available too, otherwise when you update the KSDS the AIX can not be updated correspondingly. I asume that is the case here.
User avatar
mongan
 
Posts: 211
Joined: Tue Jan 11, 2011 8:32 pm
Has thanked: 1 time
Been thanked: 5 times

Re: cannot open KSDS

Postby Robert Sample » Wed Jun 01, 2011 3:20 pm

From the second post the o/p made:
ceda define file(book) dsname('p390.book.ksds') group(XXXX)
and I have used file(book) serval times in a transation to read and write records
The KSDS worked fine -- it is the alternate index that couldn't be accessed.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to CICS

 


  • Related topics
    Replies
    Views
    Last post