Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

not able to open the hisam database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
alamelu1984

New User


Joined: 20 Apr 2007
Posts: 40
Location: bangalore

PostPosted: Wed Apr 30, 2008 12:28 pm    Post subject: not able to open the hisam database
Reply with quote

hi all,

I am trying to create a HISAM database. And for the same i have created the dbdgen ,psb and also the acb..

when i try to open my database using /start db hisamdb open

i am getting :

DFS0730I UNABLE TO OPEN DATA SET WITH DDNAME HISAMDD FOR REASON I,08, DATAB
ASE HISAMDB PSB DBDR0PSB.


I,08 Explanation: An attempt was made to open a VSAM data set for which there was no DD statement, or for dynamically allocated data sets, the data set is not yet allocated. The message indicates the ddname associated with the data set that was opened.

i have checked the ddnames for these..and they seem to be fine.. plz guide me here..

thanx in advance

regards
alamelu
Back to top
View user's profile Send private message

vasanthkumarhb

Active User


Joined: 06 Sep 2007
Posts: 276
Location: Bang,iflex

PostPosted: Wed Apr 30, 2008 12:57 pm    Post subject:
Reply with quote

Hi,

Check for the DDNAME specified in DBDGEN for HISAM, you have to check for the DDNAME given to primary dataset that is KSDS VSAM data.

also when your using GU call make sure START IMS with ROOT KEY
Back to top
View user's profile Send private message
alamelu1984

New User


Joined: 20 Apr 2007
Posts: 40
Location: bangalore

PostPosted: Wed Apr 30, 2008 3:02 pm    Post subject: Reply to: not able to open the hisam database
Reply with quote

Hi,

For your reference,let me post the structure of the dbdgen and the dbdgenjcl:

dbdgen

PRINT NOGEN
DBD NAME=HISAMDB,ACCESS=HISAM
DATASET DD1=HISAMDD,OVFLW=HISAMDO
SEGM NAME=CUSTOMER,BYTES=31,FREQ=100
FIELD NAME=(CUSID,SEQ,U),BYTES=05,START=1,TYPE=C
FIELD NAME=CUSNAME,BYTES=25,START=06,TYPE=C
SEGM NAME=EMPLOYEE,BYTES=31,FREQ=100,PARENT=CUSTOMER
FIELD NAME=(EMPID,SEQ,U),BYTES=05,START=1,TYPE=C
FIELD NAME=EMPNAME,BYTES=25,START=06,TYPE=C
DBDGEN
FINISH
END

dbdgenjcl:

//UADT013B JOB NOTIFY=&SYSUID,REGION=0M
//***********************************************
//* THIS IS A SAMPLE OF JOB - DBDGEN
//***********************************************
//DBDGEN EXEC PROC=DBDGEN,MBR=HISAMDB,SOUT='*'
//HISAMDD DD DSN=IMS910.HISAMKSD,DISP=SHR
//C.SYSIN DD DSN=UADT013.IMS.DATABASE(HISAMDB),DISP=SHR
//HISAMDO DD DSN=IMS910.OVFLOWED,DISP=SHR
//C.SYSOUT DD DSN=IMS910.HISAMKSD,DISP=SHR

this is the way i have coded them,plz do guide me here.

thanx in advance

regards
alamelu
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Sat May 03, 2008 10:20 pm    Post subject:
Reply with quote

Are your databases kown to IMS via sysgen/stages?
Back to top
View user's profile Send private message
alamelu1984

New User


Joined: 20 Apr 2007
Posts: 40
Location: bangalore

PostPosted: Mon May 05, 2008 9:48 am    Post subject:
Reply with quote

Quote:
Are your databases kown to IMS via sysgen/stages?


yes they are known to the IMS via sysgen stages.


regards
alamelu
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Mon May 05, 2008 7:47 pm    Post subject:
Reply with quote

Did you actually define the databases using IDCAMS? The DBDGEN doesn't create it for you. You have to define the VSAM datasets using DEFINE CLUSTER/DEFINE INDEX.
Back to top
View user's profile Send private message
alamelu1984

New User


Joined: 20 Apr 2007
Posts: 40
Location: bangalore

PostPosted: Tue May 06, 2008 10:55 am    Post subject:
Reply with quote

Yes I have defined them using IDCAMS .I have also defined the datasets using DEFINE CLUSTER AND DEFINE INDEX.


regards
Alamelu P.B
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts FTOPEN TEMP is failing due to dataset... mbenaud TSO/ISPF 7 Thu Jul 28, 2016 4:28 pm
This topic is locked: you cannot edit posts or make replies. Secure Browse to open dataset sandip_mainframe TSO/ISPF 3 Tue Apr 26, 2016 11:18 am
This topic is locked: you cannot edit posts or make replies. BAE Systems - Recruitment Open Days -... Express Mainframe Jobs 0 Fri Apr 22, 2016 8:19 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us