Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Error during DBDGEN

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Thu Oct 06, 2011 9:10 pm    Post subject: Error during DBDGEN
Reply with quote

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
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Oct 06, 2011 9:45 pm    Post subject: Reply to: Error during DBDGEN
Reply with quote

Quote:
DFS0944W BUILD FOR DBDSXS0P FAILED. A REQUIRED DBD WAS NOT IN DBDLIB.


I tend to trust more the ACB maintenance utility messages than Your point of view...

what is that You do not understand in the sentence A REQUIRED DBD WAS NOT IN DBDLIB ???
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Oct 06, 2011 10:00 pm    Post subject:
Reply with quote

Hello,

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

If not, do so.
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Thu Oct 06, 2011 10:53 pm    Post subject: Reply to: Error during DBDGEN
Reply with quote

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.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Oct 06, 2011 10:59 pm    Post subject: Reply to: Error during DBDGEN
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Oct 06, 2011 11:11 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Thu Oct 06, 2011 11:41 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Oct 06, 2011 11:52 pm    Post subject: Reply to: Error during DBDGEN
Reply with quote

did You look at
http://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 ?
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Fri Oct 07, 2011 12:12 am    Post subject:
Reply with quote

Yes, I did..

Code:
DBD NAME=DBDSXS0P,ACCESS=HIDAM
DATASET DD1=DDSXS00P,DEVICE=3390,SIZE=4096
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
DBDGEN
FINISH
END


Index DBD

Code:
DBD    NAME=DBDSXS0I,ACCESS=INDEX
DATASET  DD1=DDSXS00I,DEVICE=3390,SIZE=2048
SEGM   NAME=ISEGX1,PARENT=0,BYTES=32
LCHILD NAME=(SEGXS1,DBDSXS0P),INDEX=FIELD1,POINTER=SNGL
FIELD  NAME=(IFIELD2,SEQ,U),START=1,BYTES=32,TYPE=C
DBDGEN
FINISH
END


My DBD Gen works fine till Link step.

Code:
15:39:35.58 SSGBT05G C        ASMA90    0000   0:00:00.04         0      0
15:39:35.70 SSGBT05G L        IEWL      0000   0:00:00.01         0      0
15.39.36 JOB32169  DFS627I IMS RTM CLEANUP ( EOT ) COMPLETE FOR JS SSGBT05G.IMSGEN
15:39:36.06 SSGBT05G IMSGEN   DFSRRC00  0008   0:00:00.02         0      0
15:39:36.27 SSGBT05G C        ASMA90    0000   0:00:00.04         0      0
15:39:36.36 SSGBT05G L        IEWL      0000   0:00:00.01         0      0
15.39.36 JOB32169  DFS627I IMS RTM CLEANUP ( EOT ) COMPLETE FOR JS SSGBT05G.IMSGEN
15:39:36.74 SSGBT05G IMSGEN   DFSRRC00  0008   0:00:00.02         0      0

Sure, I will go through this link.

Thanks.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Oct 07, 2011 12:35 am    Post subject:
Reply with quote

Hello,

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

Also, to repeat:
Quote:
Can you find another similar definiton that is working?

You might compare the 2 and see what is specified differently. . .
I suspect that there are several similar DBDGENs on that system and referring to one that works may show what is missing/incorrect.
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Mon Oct 10, 2011 11:32 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Tue Oct 11, 2011 1:39 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Tue Oct 11, 2011 11:41 pm    Post subject: Reply to: Error during DBDGEN
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Oct 12, 2011 12:20 am    Post subject: Reply to: Error during DBDGEN
Reply with quote

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

d
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Wed Oct 12, 2011 12:36 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Wed Oct 12, 2011 1:44 am    Post subject:
Reply with quote

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

Thanks.
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 S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us