Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Rexx command to open an another text ... Bharath Vikraman PC Guides & IT News 7 Sat May 12, 2018 4:34 pm
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts Moving UDB database to Db2 on z/OS Keith Hooley DB2 4 Wed Sep 27, 2017 12:38 am
No new posts Reply MQ open error Vignesh Sid COBOL Programming 6 Thu Sep 07, 2017 6:02 pm
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us