MVSFORUMS.com

Meena · Beginner Joined: 03 Aug 2004 Posts: 20 Topics: 15

I need to see if a IMS database exist.how do i see that?

Bithead · Posted: Tue Aug 24, 2004 9:31 am Post subject:

The physical file names are either defined in the JCL (see the job or JCL procedure in this is BMP or DL/I or the JCL for the IMS control region) or look at the corresponding member of the IMS RESLIB if you are using dynamic allocation.

ramu_mohan21 · Posted: Fri Nov 12, 2004 1:30 am Post subject:

Hi Bithead,
I know whether physical file names are defined in JCL or not(If it is in the case of Pre-existing of Database).
But can you give me more clear picture on Dynamic Allocation of IMS Database. And also how can I found in IMS RESLIB whether dynamic allocation is present (or) not?
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer

Bithead · Posted: Fri Nov 12, 2004 12:59 pm Post subject:

Look for the DBD name in RESLIB. The member will contain the dataset name.

Sreejith · Posted: Mon Feb 21, 2005 9:15 am Post subject:

I am in a proccess of checking a new IMS region.
Is there a way to display All Databases available to a region ?

I tried /DIS DB all . But this displays all the DBs in the region but many of them if I tried to open in fileaid will give an error "DB Not Available'. I am looking for a comand which will display only those DBs which are working perfectly and can open by any transactions/Fileaid.

Thanks
Sreejith

Bithead · Posted: Mon Feb 21, 2005 9:27 am Post subject:

Try /DIS DB ALLOCS - this shows those that are successfully allocated though there may still be problems that only show up when the database is accessed.

Sreejith · Posted: Mon Feb 21, 2005 10:36 am Post subject:

Bithead,
thanks.. The region being a brand new and not many transactions are being used most of them shows NOTOPEN and when the testers try some transaction it gives an ALLOCF. Then we need to contact the DBAs to rectify that. I was looking to create a list of those DBs which are working OK and the ones having problem and to send a long list to the DBAs.

I think I have to do this manually by opening all DBs one by one.

thanks
Sreejith