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

Database status code AI when inserting records


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Bitneuker

CICS Moderator


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

PostPosted: Wed Nov 28, 2007 4:38 pm
Reply with quote

Any change when you type

Code:

/DIS DB DBDAPL
?
Back to top
View user's profile Send private message
anirudh1985
Currently Banned

New User


Joined: 22 Aug 2007
Posts: 66
Location: bangalore

PostPosted: Wed Nov 28, 2007 5:10 pm
Reply with quote

Bitneuker wrote:
Any change when you type

Code:

/DIS DB DBDAPL
?


no change
do u have a gmail id??
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: Wed Nov 28, 2007 5:25 pm
Reply with quote

I will investigate further and get back to you. You may use PM to contact me.
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: Thu Nov 29, 2007 6:01 am
Reply with quote

Well..........IDCAMS dummy repro doesn't do the trick as it appears.



Quote:
I take it this is an ESDS? It needs to be initially loaded with PROCOPT=L.
An open/close for EOF-mark using IDCAMS repro (dummy) is not sufficient.

If you have an HD load utility from one of those other companies, you can "initialize" it first by running it with a DUMMY input. After that, you can do an ISRT with PROCOPT=A.

An initial load with PROCOPT=L or initializing it with a load utility does things like set up the bit map. Without that, you get an AI on an ISRT if PROCOPT is not L.


Talk to your DBA and take advantage of this quote icon_wink.gif
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: Fri Nov 30, 2007 12:12 am
Reply with quote

Or check for this:
Quote:
If you have the BMC utilities, you can define the input data set as DD DUMMY and it will properly initialize the data set. Unfortunately, the IBM Load lacks that extremely useful functionality.

Back to top
View user's profile Send private message
anirudh1985
Currently Banned

New User


Joined: 22 Aug 2007
Posts: 66
Location: bangalore

PostPosted: Fri Nov 30, 2007 2:27 pm
Reply with quote

Bitneuker wrote:
Or check for this:
Quote:
If you have the BMC utilities, you can define the input data set as DD DUMMY and it will properly initialize the data set. Unfortunately, the IBM Load lacks that extremely useful functionality.



Ok i will check that out. Thanks a lot!
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 Goto page 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Job completes in JES, but the status ... IBM Tools 1
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top