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
 

 

Calculate Keylen parameter provided in IMS PSB

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

Active User


Joined: 17 Mar 2008
Posts: 148
Location: Anna NGR

PostPosted: Wed Aug 27, 2014 1:19 am    Post subject: Calculate Keylen parameter provided in IMS PSB
Reply with quote

I have a database where the database is defined in the below sturcture

Code:
1 ALEVEL0                         Key Length = 27
      2  BLEVEL1                  Key Length = 8
             3  CLEVEL1           Key Length = 3
      2  BLEVEL2                  Key Length = 15
             3  CLEVEL2           Key Length = 37
      2  BLEVEL3                  Key Length = 23
             3  CLEVEL3           Key Length = 3
      2  BLEVEL4                  Key Length = 13


When they calculate the key length for a psb accessing all the segments they are totalling to 90 bytes instead of 79 bytes which is the maximum length of a concatenated key.
Can anyone help me understand what i am missing here???
Back to top
View user's profile Send private message

Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Wed Aug 27, 2014 7:35 pm    Post subject:
Reply with quote

I know it won't hurt anything to have it be longer.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Wed Aug 27, 2014 9:40 pm    Post subject:
Reply with quote

Who did the KEYLEN calculation? It is possible that they made an error.
Back to top
View user's profile Send private message
kratos86

Active User


Joined: 17 Mar 2008
Posts: 148
Location: Anna NGR

PostPosted: Fri Aug 29, 2014 12:07 am    Post subject:
Reply with quote

It is provided by DBA and the code is running fine.
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Fri Aug 29, 2014 7:55 pm    Post subject:
Reply with quote

"Can anyone help me understand what i am missing here???"

It doesn't matter...that's what you're missing.
Back to top
View user's profile Send private message
Gary Jacek

New User


Joined: 17 Dec 2007
Posts: 44
Location: Victoria, BC, Canada

PostPosted: Fri Aug 29, 2014 10:48 pm    Post subject:
Reply with quote

Hi kratos86

If your KEYLEN specification is too small, your DBA should expect the following message during ACBGEN and you should expect the same message during execution of a Batch DLI job which uses
your PSB:

DFS0919I PSB-psbname-PCB-pcbname -KEYLEN SPECIFICATION TOO SMALL. KEYLEN SHOULD BE-xxxxx BYTES

Your DBA could simply observe the correct value shown in message DFS0919I, alter the value in the PSB source, and rerun the PSBGEN and ACBGEN.

If you are curious and you have access to ADFSSRC(DFSDLB00), ADFSSRC(DBFUDLB0) and ADFSSRC(DFSUMGT0), you should be able to examine the IMS code which issues message DFS0919I.

Since DFS0919I is an "I" level message, the return code may not be sufficient to trigger a "Code Not Running Fine" indication in your shop.

Gary
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 TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
No new posts How to display value of an exit param... lind sh CICS 2 Sun Oct 09, 2016 12:28 pm
No new posts How to calculate an specific transact... lind sh CICS 2 Tue Sep 13, 2016 9:20 pm
No new posts Send parameter for macro STIMERM from... Daniel Teolotitla PL/I & Assembler 13 Tue Jul 05, 2016 9:23 pm
No new posts COND parameter vs IF THEN ELSE Alks JCL & VSAM 11 Fri Jun 17, 2016 5:28 pm


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