IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

not able to open the hisam database


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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: 275
Location: Bang,iflex

PostPosted: Wed Apr 30, 2008 12:57 pm
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
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: 1104
Location: The Netherlands at Hole 19

PostPosted: Sat May 03, 2008 10:20 pm
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
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: 1104
Location: The Netherlands at Hole 19

PostPosted: Mon May 05, 2008 7:47 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Calling an Open C library function in... CICS 1
No new posts What database does Jobtrac use CA Products 4
No new posts Open VSAM File in IMS DC Region - DFS... IMS DB/DC 0
No new posts Capturing COBOL job and program names... All Other Mainframe Topics 2
No new posts Products/Tools to Optimize Adabas Dat... Compuware & Other Tools 2
Search our Forums:

Back to Top