Error during DBDGEN

aprocon · New User Joined: 26 Oct 2010 Posts: 41 Location: chennai

Hi,

I am trying to create a test database. My DBD is below.

SEGM NAME=SEGXS1,PARENT=0,BYTES=140,PTR=TWINBWD
FIELD NAME=(FIELD1,SEQ,U),BYTES=32,START=1,TYPE=C
LCHILD NAME=(ISEGX1,DBDSXS0I),POINTER=INDX

My Index DBD is:

SEGM NAME=ISEGX1,PARENT=0,BYTES=32
LCHILD NAME=(SEGXS1,DBDSXS0P),INDEX=FIELD1
FIELD NAME=(IFIELD2,SEQ,U),START=1,BYTES=32,TYPE=C

I get this error message.

BUILD DBD=(DBDSXS0P)
DFS0927I INDEX DBD --DBDSXS0I-- INDEXES NON-EXISTANT FIELD IN DBD --DBDSXS0P
DFS0944W BUILD FOR DBDSXS0P FAILED. A REQUIRED DBD WAS NOT IN DBDLIB.

DFS0590I END OF ACBLIB MAINTENANCE. HIGHEST CONDITION CODE WAS 00000008

However, I have defined the field Field1 in both data and index.

Please help me understand where i am messing up.

Thanks

enrico-sorichetti · Posted: Thu Oct 06, 2011 9:45 pm

dick scherrer · Posted: Thu Oct 06, 2011 10:00 pm

Hello,

Have you talked with your dba or some senior who knows how to do this on your system.

If not, do so.

aprocon · New User Joined: 26 Oct 2010 Posts: 41 Location: chennai

Unfortunately I am the only DBA at offshore. My only onsite counter part seems to be busy with new projects. I have been trying this for over a month. So, I thought i would put this up here and get some solutions/suggestions

Thanks for your kind response.

enrico-sorichetti · Posted: Thu Oct 06, 2011 10:59 pm

You should have at least the good sense of posting the whole DBDGEN deck,
not just three lines
the message tells that nowhere in the dbdlib exists a DBD with the name You used PERIOD, FULL STOP, AMEN
until You generate a DBD with that name or better syncronize tha names of the object used very little can be done, but repeat the advice.
keep things in sync

remember
we reply on our time and at no charge
it seems a bit unethical to expect people from a forum to take care of issues due a poor organization

dick scherrer · Posted: Thu Oct 06, 2011 11:11 pm

Hello,

Can you find another similar definiton that is working?

You might compare the 2 and see what is specified differently. . .

Unfortunately, i don't "do" IMS.

More unfortunate is the number of organizations that do not believe they need to have the proper resources available to support their activities.

aprocon · New User Joined: 26 Oct 2010 Posts: 41 Location: chennai

Sorry about that enrico. But that is what the fact is. This is not an user issue, I am just trying to setup my own database and there by learn and grow. but just do not have proper assistance.

I appreciate your time spent on this and Sorry for troubling you guys.

enrico-sorichetti · Posted: Thu Oct 06, 2011 11:52 pm

did You look at
www.redbooks.ibm.com/abstracts/sg245352.html?Open
not the newest but pretty useful!

again, did You check that You had all the names in sync ?

aprocon · New User Joined: 26 Oct 2010 Posts: 41 Location: chennai

Yes, I did..

dick scherrer · Posted: Fri Oct 07, 2011 12:35 am

Hello,

Yup, reading the material is surely a good thing to do

Also, to repeat:

aprocon · New User Joined: 26 Oct 2010 Posts: 41 Location: chennai

Hi Dick and Enrico

Thanks for your assistance.

I was able to create a test database. Thanks for the document provided it was very helpful indeed.

I had to Gen the PSB before DBD. that resoved my issue.

Thanks

Ed Goodman · Active Member Joined: 08 Jun 2011 Posts: 556 Location: USA

I doubt genning a PSB made any difference.

You should have been able to run the DBD gen on the primary, then the DBD gen on the index, both to the same DBD library.

My guess, and it's a total guess, is that you ran the right DBD gen when you thought you were running the PSB gen. That put the DBD in the library, then the second step would work.

I base this on the fact that you are seeing ACB gen messages instead of DBD gen messages.

aprocon · New User Joined: 26 Oct 2010 Posts: 41 Location: chennai

No,

I had to gen the PSB first to make ACBLIB PSB reference to the DBD.

After running the gen job for PSB i genned the same DBD and it went fine.

dick scherrer · Posted: Wed Oct 12, 2011 12:20 am

Good to hear it is working - thank you for letting us know

d

Ed Goodman · Active Member Joined: 08 Jun 2011 Posts: 556 Location: USA

Ahhhh... by having a PSB that referenced the DBD during the ACB gen, it forced the DBD to be genned with the new field. We've had that happen with new indexes.

If no PSB in the library uses a given DBD, it won't get updated in the ACB library.

It's important to keep them straight...DBD and ACB are NOT the same thing.

aprocon · New User Joined: 26 Oct 2010 Posts: 41 Location: chennai

I am obliged to let you all know that it is working.

Thanks.