I am running Valence30
Version 3.0.20110509.0
I have a file that is indexed but when I click on File Maintenance and enter the file name it gives me:
File Is Not Keyed
This file can only be used to create an inquiry program. Continue?
There is only the one file CUNA00 in the library JMALIB which is in the library list for Valence test enviroment.
Here is the command: DSPFD FILE(CUNA00) OUTPUT(*PRINT)
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 1
File . . . . . . . . . . . : CUNA00
Library . . . . . . . . . : *LIBL
Type of information . . . . : *ALL
File attributes . . . . . . : *ALL
System . . . . . . . . . . : *LCL
Processor . . . . . . . . . : IBM AS/400 Display File Description Processor
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Data Base File Attributes
Externally described file . . . . . . . . . : Yes
File level identifier . . . . . . . . . . . : 1110719085625
Creation date . . . . . . . . . . . . . . . : 07/19/11
Text 'description' . . . . . . . . . . . . : TEXT DDS OUTPUT SPECS TO COPY TO QDDSSRC
Distributed file . . . . . . . . . . . . . : No
Partitioned SQL Table . . . . . . . . . . . : No
DBCS capable . . . . . . . . . . . . . . . : No
Maximum members . . . . . . . . . . . . . . : MAXMBRS *NOMAX
Number of constraints . . . . . . . . . . . : 0
Number of triggers . . . . . . . . . . . . : 0
Number of members . . . . . . . . . . . . . : 1
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . . : RECOVER *NO
Force keyed access path . . . . . . . . . . : FRCACCPTH *NO
Member size . . . . . . . . . . . . . . . . : SIZE *NOMAX
Allocate storage . . . . . . . . . . . . . : ALLOCATE *NO
Contiguous storage . . . . . . . . . . . . : CONTIG *NO
Preferred storage unit . . . . . . . . . . : UNIT *ANY
Records to force a write . . . . . . . . . : FRCRATIO *NONE
Maximum file wait time . . . . . . . . . . : WAITFILE 30
Maximum record wait time . . . . . . . . . : WAITRCD 60
Max % deleted records allowed . . . . . . . : DLTPCT *NONE
Reuse deleted records . . . . . . . . . . . : REUSEDLT *YES
Coded character set identifier . . . . . . : CCSID 37
Allow read operation . . . . . . . . . . . : Yes
Allow write operation . . . . . . . . . . . : Yes
Allow update operation . . . . . . . . . . : ALWUPD *YES
Allow delete operation . . . . . . . . . . : ALWDLT *YES
Record format level check . . . . . . . . . : LVLCHK *NO
Access path . . . . . . . . . . . . . . . . : Keyed
Access path size . . . . . . . . . . . . . : ACCPTHSIZ *MAX1TB
Access path logical page size . . . . . . . : PAGESIZE *KEYLEN
Maximum key length . . . . . . . . . . . . : 12
Maximum record length . . . . . . . . . . . : 256
Volatile . . . . . . . . . . . . . . . . . : No
File is currently journaled . . . . . . . . : No
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 2
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Access Path Description
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Unique key values required . . . . . . . . : UNIQUE No
Key order . . . . . . . . . . . . . . . . . : Not specified
Access path journaled . . . . . . . . . . . : No
Access path . . . . . . . . . . . . . . . . : Keyed
Constraint Type . . . . . . . . . . . . . . : NONE
Number of key fields . . . . . . . . . . . : 2
Record format . . . . . . . . . . . . . . . : CUNA00R
Key field . . . . . . . . . . . . . . . . : CU#
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : SIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : MEMB5
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : SIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ *HEX
Language identifier . . . . . . . . . . . . : LANGID ENU
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 3
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Member Description
Member . . . . . . . . . . . . . . . . . . : MBR CUNA00
Member level identifier . . . . . . . . . : 1110719085625
Member creation date . . . . . . . . . . : 07/19/11
Text 'description' . . . . . . . . . . . : TEXT DDS OUTPUT SPECS TO COPY TO QDDSSRC
Expiration date for member . . . . . . . : EXPDATE *NONE
Access path maintenance . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . : RECOVER *NO
Member size . . . . . . . . . . . . . . . : SIZE *NOMAX
Current number of records . . . . . . . . : 10
Number of deleted records . . . . . . . . : 0
Allocate storage . . . . . . . . . . . . : ALLOCATE *NO
Contiguous storage . . . . . . . . . . . : CONTIG *NO
Preferred storage unit . . . . . . . . . : UNIT *ANY
Records to force a write . . . . . . . . : FRCRATIO *NONE
Share open data path . . . . . . . . . . : SHARE *NO
Max % deleted records allowed . . . . . . : DLTPCT *NONE
Number of member accesses . . . . . . . . : 0
Data Space Activity Statistics . . . . . :
Data space size in bytes . . . . . . . : 12288
Physical file open accesses . . . . . . : 4
Physical file close accesses . . . . . : 4
Write operations . . . . . . . . . . . : 10
Update operations . . . . . . . . . . . :
Delete operations . . . . . . . . . . . :
Logical Reads . . . . . . . . . . . . . : 6
Physical Reads . . . . . . . . . . . . : 1
Clear operations . . . . . . . . . . . :
Data space copy operations . . . . . . :
Reorganize operations . . . . . . . . . :
Access paths builds/rebuilds . . . . . : 1
Records rejected by key selection . . . :
Records rejected by non-key selection . :
Records rejected by group-by selection. :
Access Path Activity Statistics . . . . . :
Access path logical reads . . . . . . . : 11
Access path physical reads . . . . . . :
Access path size . . . . . . . . . . . : 28672
Number of access path entries . . . . . : 10
Access path valid . . . . . . . . . . . : Yes
Implicit access path sharing . . . . . : No
Access path journaled . . . . . . . . . : No
Number of unique partial key values . . :
Key field 1 . . . . . . . . . . . . . : 1
Key fields 1 - 2 . . . . . . . . . . : 10
Last change date/time . . . . . . . . . . : 07/19/11 08:58:05
Last save date/time . . . . . . . . . . . :
Last restore date/time . . . . . . . . . :
Last used date . . . . . . . . . . . . . : 07/19/11
Days used count . . . . . . . . . . . . . : 1
Reset date . . . . . . . . . . . . . . :
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 4
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Member Description
Object restored with partial transactions,
apply journal changes required . . . . : *NO
Partial transaction exists,
roll back ended . . . . . . . . . . . . : *NO
Starting journal receiver for apply . . . :
Library . . . . . . . . . . . . . . . . :
ASP Device . . . . . . . . . . . . . . :
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 5
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Record Format List
Record Format Level
Format Fields Length Identifier
CUNA00R 42 256 57DE069ED406E
Text . . . : CUNA00
Total number of formats . . . . . . . . . : 1
Total number of fields . . . . . . . . . . : 42
Total record length . . . . . . . . . . . : 256
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 6
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Member List
Source Creation Last Change Deleted
Member Size Type Date Date Time Records Records
CUNA00 40960 07/19/11 07/19/11 08:58:05 10 0
Text: DDS OUTPUT SPECS TO COPY TO QDDSSRC
Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total records . . . . . . . . . . . . . . : 10
Total deleted records . . . . . . . . . . : 0
Total of member sizes . . . . . . . . . . : 40960
Can anyone tell me what is wrong?
James
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Version 3.0.20110509.0
I have a file that is indexed but when I click on File Maintenance and enter the file name it gives me:
File Is Not Keyed
This file can only be used to create an inquiry program. Continue?
There is only the one file CUNA00 in the library JMALIB which is in the library list for Valence test enviroment.
Here is the command: DSPFD FILE(CUNA00) OUTPUT(*PRINT)
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 1
File . . . . . . . . . . . : CUNA00
Library . . . . . . . . . : *LIBL
Type of information . . . . : *ALL
File attributes . . . . . . : *ALL
System . . . . . . . . . . : *LCL
Processor . . . . . . . . . : IBM AS/400 Display File Description Processor
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Data Base File Attributes
Externally described file . . . . . . . . . : Yes
File level identifier . . . . . . . . . . . : 1110719085625
Creation date . . . . . . . . . . . . . . . : 07/19/11
Text 'description' . . . . . . . . . . . . : TEXT DDS OUTPUT SPECS TO COPY TO QDDSSRC
Distributed file . . . . . . . . . . . . . : No
Partitioned SQL Table . . . . . . . . . . . : No
DBCS capable . . . . . . . . . . . . . . . : No
Maximum members . . . . . . . . . . . . . . : MAXMBRS *NOMAX
Number of constraints . . . . . . . . . . . : 0
Number of triggers . . . . . . . . . . . . : 0
Number of members . . . . . . . . . . . . . : 1
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . . : RECOVER *NO
Force keyed access path . . . . . . . . . . : FRCACCPTH *NO
Member size . . . . . . . . . . . . . . . . : SIZE *NOMAX
Allocate storage . . . . . . . . . . . . . : ALLOCATE *NO
Contiguous storage . . . . . . . . . . . . : CONTIG *NO
Preferred storage unit . . . . . . . . . . : UNIT *ANY
Records to force a write . . . . . . . . . : FRCRATIO *NONE
Maximum file wait time . . . . . . . . . . : WAITFILE 30
Maximum record wait time . . . . . . . . . : WAITRCD 60
Max % deleted records allowed . . . . . . . : DLTPCT *NONE
Reuse deleted records . . . . . . . . . . . : REUSEDLT *YES
Coded character set identifier . . . . . . : CCSID 37
Allow read operation . . . . . . . . . . . : Yes
Allow write operation . . . . . . . . . . . : Yes
Allow update operation . . . . . . . . . . : ALWUPD *YES
Allow delete operation . . . . . . . . . . : ALWDLT *YES
Record format level check . . . . . . . . . : LVLCHK *NO
Access path . . . . . . . . . . . . . . . . : Keyed
Access path size . . . . . . . . . . . . . : ACCPTHSIZ *MAX1TB
Access path logical page size . . . . . . . : PAGESIZE *KEYLEN
Maximum key length . . . . . . . . . . . . : 12
Maximum record length . . . . . . . . . . . : 256
Volatile . . . . . . . . . . . . . . . . . : No
File is currently journaled . . . . . . . . : No
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 2
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Access Path Description
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Unique key values required . . . . . . . . : UNIQUE No
Key order . . . . . . . . . . . . . . . . . : Not specified
Access path journaled . . . . . . . . . . . : No
Access path . . . . . . . . . . . . . . . . : Keyed
Constraint Type . . . . . . . . . . . . . . : NONE
Number of key fields . . . . . . . . . . . : 2
Record format . . . . . . . . . . . . . . . : CUNA00R
Key field . . . . . . . . . . . . . . . . : CU#
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : SIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : MEMB5
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : SIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ *HEX
Language identifier . . . . . . . . . . . . : LANGID ENU
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 3
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Member Description
Member . . . . . . . . . . . . . . . . . . : MBR CUNA00
Member level identifier . . . . . . . . . : 1110719085625
Member creation date . . . . . . . . . . : 07/19/11
Text 'description' . . . . . . . . . . . : TEXT DDS OUTPUT SPECS TO COPY TO QDDSSRC
Expiration date for member . . . . . . . : EXPDATE *NONE
Access path maintenance . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . : RECOVER *NO
Member size . . . . . . . . . . . . . . . : SIZE *NOMAX
Current number of records . . . . . . . . : 10
Number of deleted records . . . . . . . . : 0
Allocate storage . . . . . . . . . . . . : ALLOCATE *NO
Contiguous storage . . . . . . . . . . . : CONTIG *NO
Preferred storage unit . . . . . . . . . : UNIT *ANY
Records to force a write . . . . . . . . : FRCRATIO *NONE
Share open data path . . . . . . . . . . : SHARE *NO
Max % deleted records allowed . . . . . . : DLTPCT *NONE
Number of member accesses . . . . . . . . : 0
Data Space Activity Statistics . . . . . :
Data space size in bytes . . . . . . . : 12288
Physical file open accesses . . . . . . : 4
Physical file close accesses . . . . . : 4
Write operations . . . . . . . . . . . : 10
Update operations . . . . . . . . . . . :
Delete operations . . . . . . . . . . . :
Logical Reads . . . . . . . . . . . . . : 6
Physical Reads . . . . . . . . . . . . : 1
Clear operations . . . . . . . . . . . :
Data space copy operations . . . . . . :
Reorganize operations . . . . . . . . . :
Access paths builds/rebuilds . . . . . : 1
Records rejected by key selection . . . :
Records rejected by non-key selection . :
Records rejected by group-by selection. :
Access Path Activity Statistics . . . . . :
Access path logical reads . . . . . . . : 11
Access path physical reads . . . . . . :
Access path size . . . . . . . . . . . : 28672
Number of access path entries . . . . . : 10
Access path valid . . . . . . . . . . . : Yes
Implicit access path sharing . . . . . : No
Access path journaled . . . . . . . . . : No
Number of unique partial key values . . :
Key field 1 . . . . . . . . . . . . . : 1
Key fields 1 - 2 . . . . . . . . . . : 10
Last change date/time . . . . . . . . . . : 07/19/11 08:58:05
Last save date/time . . . . . . . . . . . :
Last restore date/time . . . . . . . . . :
Last used date . . . . . . . . . . . . . : 07/19/11
Days used count . . . . . . . . . . . . . : 1
Reset date . . . . . . . . . . . . . . :
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 4
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Member Description
Object restored with partial transactions,
apply journal changes required . . . . : *NO
Partial transaction exists,
roll back ended . . . . . . . . . . . . : *NO
Starting journal receiver for apply . . . :
Library . . . . . . . . . . . . . . . . :
ASP Device . . . . . . . . . . . . . . :
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 5
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Record Format List
Record Format Level
Format Fields Length Identifier
CUNA00R 42 256 57DE069ED406E
Text . . . : CUNA00
Total number of formats . . . . . . . . . : 1
Total number of fields . . . . . . . . . . : 42
Total record length . . . . . . . . . . . : 256
5722SS1 V5R4M0 060210 Display File Description 7/19/11 9:46:21 Page 6
File . : CUNA00 Library . : JMALIB Type of file . : Physical *DATA Auxiliary Storage Pool ID . : 00001
Member List
Source Creation Last Change Deleted
Member Size Type Date Date Time Records Records
CUNA00 40960 07/19/11 07/19/11 08:58:05 10 0
Text: DDS OUTPUT SPECS TO COPY TO QDDSSRC
Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total records . . . . . . . . . . . . . . : 10
Total deleted records . . . . . . . . . . : 0
Total of member sizes . . . . . . . . . . : 40960
Can anyone tell me what is wrong?
James
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Comment