| View previous topic :: View next topic |
| Author |
Message |
cjm13905
Beginner
Joined: 29 Apr 2005
Posts: 4
Topics: 1
|
 Posted: Fri Apr 29, 2005 8:26 am Post subject: vsam alt index and Not available for this type of processing |
 |
|
First time poster here.
We are an IBM mainframe shop with CICS.
We have a VSAM file called BIO and one AIX defined.
I am trying to define another AIX.
When I do the IDCAMS DEFINE, BLDINDX, and DEFINE it all works fine.
When I attempt to open the second AIX on CICS I am getting an error.
First I enable it fine on CICS, but when I try to open I get the error.
Our CICS systems programmer tells me that in the CICS log she is seeing the message "Not available for this type of processing".
My define is :
DEFINE ALTERNATEINDEX -
(NAME(xxxx.yy.zzz.BIO.ALTID2) -
VOLUMES(xxx007) -
RELATE (xxxx.yy.zzz.BIO) -
CYLINDERS(10 5) -
KEYS(24 33) -
RECORDSIZE(186 349) -
SHAREOPTIONS(2 3) -
UNIQUE -
NONUNIQUEKEY -
UPGRADE) -
DATA -
(NAME(xxxx.yy.zzz.BIO.ALTID2.DATA)) -
INDEX -
(NAME(xxxx.yy.zzz.BIO.ALTID2.INDEX))
The Build Path is:
DEFINE PATH -
(NAME(xxx.yy.zzz.BIO.ID2) -
PATHENTRY(xxx.yy.zzz.BIO.ALTID2) -
UPDATE)
Any ideas are much appreciated.
Thanks |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Fri Apr 29, 2005 8:50 am Post subject: |
|
|
cjm13905,
I see that you have UPGRADE option on Alternate Index definition. If the alternate index is defined when the base cluster is open, the UPGRADE attribute takes effect the next time the base cluster is opened.
So close the base cluster and re-open it once again and see if it solves the error.
Hope this helps...
Cheers
kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
cjm13905
Beginner
Joined: 29 Apr 2005
Posts: 4
Topics: 1
|
| Posted: Fri Apr 29, 2005 10:10 am Post subject: |
|
|
| kolusu wrote: | cjm13905,
I see that you have UPGRADE option on Alternate Index definition. If the alternate index is defined when the base cluster is open, the UPGRADE attribute takes effect the next time the base cluster is opened.
So close the base cluster and re-open it once again and see if it solves the error.
Hope this helps...
Cheers
kolusu |
That didn't help.
Thanks though. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Fri Apr 29, 2005 10:23 am Post subject: |
|
|
cjm13905 ,
what is the exact error message when you tried to open ? What is the resp code?
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
cjm13905
Beginner
Joined: 29 Apr 2005
Posts: 4
Topics: 1
|
| Posted: Fri Apr 29, 2005 10:37 am Post subject: |
|
|
| kolusu wrote: | cjm13905 ,
what is the exact error message when you tried to open ? What is the resp code?
Kolusu |
I get the error when I am doing CEMT SET FI(ASBIO*) OPE ENA
I don't think you can get the resp code from CEMT SET can you ?
All I see is the OPEN/CLOSE FAILED message.
Here are the TBL defines for the Alt index. It displays better with
COURIER font, but I don't see how you can change the font here.
| Code: |
VIEW FI(ASBIOY) GROUP(FAFCTY2K)
OBJECT CHARACTERISTICS CICS RELEASE
CEDA View File( ASBIOY )
File : ASBIOY
Group : FAFCTY2K
DEScription :
VSAM PARAMETERS
DSNAme : xxxx.yy.zzz.BIO.ID2
Password : PASSWORD NOT SPECIFIED
Lsrpoolid : None 1-8 | None
DSNSharing : Allreqs Allreqs | Modifyreqs
STRings : 002 1-255
Nsrgroup : ASBIOX
REMOTE ATTRIBUTES
REMOTESystem :
REMOTEName :
RECORDSize : 1-32767
Keylength : 1-255
INITIAL STATUS
STAtus : Enabled Enabled | Disabled | Unenabled
VIEW FI(ASBIOY) GROUP(FAFCTY2K)
OBJECT CHARACTERISTICS CICS RELEASE = 0410
CEDA View File( ASBIOY )
Opentime : Firstref Firstref | Startup
DIsposition : Share Share | Old
BUFFERS
DAtabuffers : 00003 2-32767
Indexbuffers : 00002 1-32767
DATATABLE PARAMETERS
Table : No No | Cics | User
Maxnumrecs : 16-16777215
DATA FORMAT
RECORDFormat : V V | F
OPERATIONS
Add : No No | Yes
BRowse : Yes No | Yes
DELete : No No | Yes
REAd : Yes Yes | No
Update : No No | Yes
AUTO JOURNALLING
VIEW FI(ASBIOY) GROUP(FAFCTY2K)
OBJECT CHARACTERISTICS CICS RELEASE = 0410
CEDA View File( ASBIOY )
JOurnal : No No | 1-99
JNLRead : None None | Updateonly | Readonly | All
JNLSYNCRead : No No | Yes
JNLUpdate : No No | Yes
JNLAdd : None None | Before | AFter | ALl
JNLSYNCWrite : Yes Yes | No
RECOVERY PARAMETERS
RECOVery : None None | Backoutonly | All
Fwdrecovlog : No No | 1-99
BAckuptype : Static Static | Dynamic
SECURITY
RESsecnum : 00 0-24 | Public
|
|
|
| Back to top |
|
|
cjm13905
Beginner
Joined: 29 Apr 2005
Posts: 4
Topics: 1
|
| Posted: Fri Apr 29, 2005 12:44 pm Post subject: |
|
|
The lsrpoolid was set to None.
When this was changed to 1 the file opened. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Fri Apr 29, 2005 2:28 pm Post subject: |
|
|
Thanks for the update cjm13905 !
kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
