| View previous topic :: View next topic |
| Author |
Message |
rajat_gupta
Beginner
Joined: 30 May 2007
Posts: 13
Topics: 5
Location: India
|
 Posted: Sun Sep 30, 2007 6:11 am Post subject: Urgent Help required on 'AI' return code of IMS-DB |
 |
|
Hi All ,
I am getting 'AI' - Data management OPEN error in my COBOL IMSDB program . The return code is coming after a 'GN' call on a GSAM input file which I am providing thru job.
If anyone has faced this problem earlier and has any solution then pls suggest.Thanks for your quick response.
Rajat
_________________
Rajat Gupta
when depressing thoughts seem to get you down
Put a smile on your face and thank God you're alive and still around. |
|
| Back to top |
|
 |
Nic Clouston
Advanced
Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home
|
| Posted: Sun Sep 30, 2007 1:05 pm Post subject: |
|
|
which of the possibilities provided in the manual for AI status code have you managed to determine are NOT causing your error? Have you got message number DFS0730I - if so what does it say?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL. |
|
| Back to top |
|
|
deepeshk79
Beginner
Joined: 20 Jun 2003
Posts: 112
Topics: 48
Location: Bangalore
|
| Posted: Thu Oct 04, 2007 2:12 am Post subject: |
|
|
Rajat,
Check the below
-- In the Run JCL are you pointing to proper DD Statements (thats given in the DBD) for your database ?
-- Is the PROCOPT proper ?
Thanks,
Deepesh |
|
| Back to top |
|
|
vivek1983
Intermediate
Joined: 20 Apr 2006
Posts: 222
Topics: 24
|
| Posted: Thu Oct 04, 2007 5:24 am Post subject: |
|
|
rajat_gupta,
Got this from some manual. Hope it helps:
| Quote: |
AI
Explanation: A data management open error occurred. Some possible reasons are:
1. There is an error in the DD statements.
2. Neither DD statements nor DFSMDA dynamic allocation members were provided for this database.
3. The data set OPEN request did not specify load mode, but the data set was empty. An empty data set requires the load option in the PCB.
4. The buffer is too small to hold a record that was read at open time. See the storage estimates in IMS/ESA System Administration Guide for specification of the minimum buffer pool size.
5. There were no DD statements or DFSMDA members supplied for logically-related databases.
6. For an OSAM data set, the DSORG field of the OSAM DCB, DSCB, or JFCB does not specify PS or DA.
7. For an old OSAM data set, the BUFL or BLKSIZE field in the DSCB is zero.
8. The data set is being opened for load, and the processing option for one or more segments is other than L or LS.
9. The allocation of the OSAM data set is invalid. The allocation is probably (1,,1) rather than (1,1) and this causes the DSORG to be P0.
10. The processing option is L, the OSAM data set is old, and the DSCB LRECL and/or BLKSIZE does not match the DBD LRECL and/or BLKSIZE.
11. Incorrect or missing information prevented IMS from determining the block size or the logical record length.
12. A catalog was not available for accessing a VSAM database that was requested.
13. OS could not perform an OPEN, but the I/O request is valid. Either the data definition information is incorrect, or information is missing.
14. RACF was used to protect the OSAM data set and the control region has no update authorization.
If IMS returns message DFS0730I, you can determine the cause of the OPEN failure from this message in the job log. For more information, see the description of this message in IMS/ESA Messages and Codes.
Programmer Response: These kinds of problems often require the help of a system programmer or system administrator. But before you go to one of these specialists, there are some things you can do:
Check the DD statements. Make sure that the ddname is the same as the name specified on the DATASET statement of the DBD. The segment name area in the DB PCB (call level), or in the DIB (command level) has the ddname of the data set that couldn't be opened.
Check the PSB and make sure that the appropriate processing options have been specified for each of the DB PCBs that your program uses.
|
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay) |
|
| Back to top |
|
|
vjkumk
Beginner
Joined: 28 Sep 2005
Posts: 98
Topics: 33
|
| Posted: Sun Oct 21, 2007 8:10 pm Post subject: |
|
|
AI(unable to open the database),check whether the clusters needed for a databasehave been mentioned in run jcl or check whether the clusters are empty and make sure what ever database mentioned in psb,those corresponding clusters are mentioned in execution jcl.
cheers
vj |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
