I am getting an abend message - AK - An SSA contains an invalid field name, or the field name is not defined in the DBD.
I have changed the PSB to add a new PCB and the DBA's have created a new Secondary Indexing on the DB.
Here is the new PCB that is added - Is there any thing wrong with the PCB definition?
Code:
PCB TYPE=DB,DBDNAME=GNAJDIDB,KEYLEN=36,PROCOPT=GOT, X
PROCSEQ=GNAJDIS1, X
PCBNAME=GNAJDIS1
SENSEG NAME=GNAJDRT,PARENT=0
SENSEG NAME=GNAJDOS,PARENT=GNAJDRT
And these are the DBD changes - Bolded the new index field.
DSG1 DATASET DD1=GNAJDIDB,SIZE= 4096),SCAN=3
SEGM NAME=GNAJDRT,BYTES=50,PTR=(T), X
PARENT=0,RULES=(LLL)
FIELD NAME=GNAJDRK,SEQ,U),BYTES=9,START=1,TYPE=C
FIELD NAME=NPI,BYTES=10,START=40,TYPE=C
FIELD NAME=/SX1,BYTES=4,START=1
LCHILD NAME=(GNAJDXP,GNAJDINX),PTR=INDX
LCHILD NAME=(GNAJDS1,GNAJDIS1),PTR=INDX
XDFLD NAME=NPIS,SEGMENT=GNAJDRT,NULLVAL=X'40',
SRCH=(NPI), X
SUBSEQ=(/SX1)
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
You've put a lot of text in your topic but could you please explain what your intension is? Looks like secondary indexing to me. This manual explaines s.i. For your understanding please read a little bit and verify your stuff.
George,
Thanks for the link on Secondary Indexing, it was definitely a help.
The problem I was facing is a new Secondary index was created on a DB. I was trying to access it with the SSA (new one).
When I execute it (its an online program), I was getting the IMS abend - AK.
So in my my previous message I have pasted the PCB, DBD and SSA to find out if any thing was wrong with those definitions.
I think this problem got resolved now. I have realised I was using the DB's from a different region, other than the one where the changes actually occurred.
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
srikanthreddyb wrote:
George,
Thanks for the link on Secondary Indexing, it was definitely a help.
Was a pleasure to me. Instead of telling people how to solve their problem I prefer to have them understand what they are doing (or at least what they want to do).
Does your answer mean your problem in solved in such way you can proceed?