How to tell how a Physical File was created

[copr...@gmail.com]

I have a Physical File that the source matches the object. But I get a
diffenrent 'File level identifier' and 'Record Format Level identifier'
when I recompile the source. When I run the DSPFD and DSFFD they are
exactly the same except for the two level identifiers and the compile
date. The Original was compiled in 06/09/95. I just need to know the
creation options so I can recompile the file without recompiling 500
programs to correct the level checks. Thanks for your help.

[Christian Gstalder]

Hi,

The File level identifier is based on the creation date and is checked when
restored on an existing file.

The Record Format Level identifier is based on the Record Format name, the
number, the name and the type of the fields.

Have you tried a DSPOBJD DETAIL(*SERVICE) ??

--

Christian Gstalder

<copr...@gmail.com> a écrit dans le message de
news:1112887598.1...@z14g2000cwz.googlegroups.com...

[copr...@gmail.com]

The original OS version is V2R3M0 (we are currently on V5R2M0) and the
system name is different. So I guess there is no way to recreate the
same level check IDs. Thanks for your help.

[Christian Gstalder]

I've never had your problem.

We have files coming from S38 without any problem. I've just recompiled a
file who was first created on a S38. The Record Format Level IDs are the
same.

The Record Format Level ID is neither based on the OS version nor the system
name.

--

Christian Gstalder

<copr...@gmail.com> a écrit dans le message de

news:1112891864.1...@f14g2000cwb.googlegroups.com...

[Charles Wilt]

No, but that's ok.

You only get a HLL "Level Check" when the "Format Level Identifier" is
different.

Example output from DSPFD:

Record Format List
Record Format Level
Format Fields Length Identifier
ACTGLP 3 31 2812BBF8AD26F

HTH,
Charles

In article <1112891864.1...@f14g2000cwb.googlegroups.com>,
copr...@gmail.com says...

[copr...@gmail.com]

original File (DSPDF)
--------------------------------------
5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:24:40 Page 1

File . . . . . . . . . . . : VNDMST
Library . . . . . . . . . : *LIBL
Type of information . . . . : *ALL
File attributes . . . . . . : *ALL
System . . . . . . . . . . : *LCL
Processor . . . . . . . . . : IBM AS/400 Display File Description
Processor

File . : VNDMST Library . : BIGLIB Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Data Base File Attributes

Externally described file . . . . . . . . . : Yes
File level identifier . . . . . . . . . . . :
0950609091150
Creation date . . . . . . . . . . . . . . . : 06/09/95
Text 'description' . . . . . . . . . . . . : TEXT Vendor
Master - PF
Distributed file . . . . . . . . . . . . . : No
DBCS capable . . . . . . . . . . . . . . . : No
Maximum members . . . . . . . . . . . . . . : MAXMBRS 1
Number of constraints . . . . . . . . . . . : 0
Number of triggers . . . . . . . . . . . . : 0
Number of members . . . . . . . . . . . . . : 1
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . . : RECOVER *AFTIPL
Force keyed access path . . . . . . . . . . : FRCACCPTH *NO
Member size SIZE
Initial number of records . . . . . . . . : 5000
Increment number of records . . . . . . . : 2000
Maximum number of increments . . . . . . : 3
Record capacity . . . . . . . . . . . . . . : 11000
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 *IMMED
Maximum record wait time . . . . . . . . . : WAITRCD 60
Max % deleted records allowed . . . . . . . : DLTPCT *NONE
Reuse deleted records . . . . . . . . . . . : REUSEDLT *NO
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 *MAX4GB
Maximum key length . . . . . . . . . . . . : 3
Maximum record length . . . . . . . . . . . : 175
File is currently journaled . . . . . . . . : No
Current or last journal . . . . . . . . . . : CSQ1$
Library . . . . . . . . . . . . . . . . . : CSJLIB
Journal images . . . . . . . . . . . . . . : IMAGES *BOTH
Journal entries to be omitted . . . . . . . : OMTJRNE *OPNCLO
Last journal start date/time . . . . . . . : 07/27/96
14:55:33

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:24:40 Page 2

File . : VNDMST Library . : BIGLIB Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Access Path Description

Access path maintenance . . . . . . . . . . : MAINT *IMMED
Unique key values required . . . . . . . . : UNIQUE Yes
Access path journaled . . . . . . . . . . . : No
Access path . . . . . . . . . . . . . . . . : Keyed
Constraint Type . . . . . . . . . . . . . . : NONE
Number of key fields . . . . . . . . . . . : 1
Record format . . . . . . . . . . . . . . . : VDMFMT
Key field . . . . . . . . . . . . . . . . : VMVNO
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ *HEX

Language identifier . . . . . . . . . . . . : LANGID ENU

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:24:40 Page 3

File . : VNDMST Library . : BIGLIB Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Member Description

Member . . . . . . . . . . . . . . . . . . : MBR VNDMST
Member level identifier . . . . . . . . . :
0950609091150
Member creation date . . . . . . . . . . : 06/09/95
Text 'description' . . . . . . . . . . . : TEXT Vendor
Master - PF
Expiration date for member . . . . . . . : EXPDATE *NONE
Access path maintenance . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . : RECOVER *AFTIPL
Member size SIZE
Initial number of records . . . . . . . : 5000
Increment number of records . . . . . . : 2000
Maximum number of increments . . . . . : 3
Current number of increments . . . . . . : 0
Record capacity . . . . . . . . . . . . . : 11000
Current number of records . . . . . . . . : 1030
Number of deleted records . . . . . . . . : 256
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 *YES
Max % deleted records allowed . . . . . . : DLTPCT *NONE
Number of member accesses . . . . . . . . : 0
Data Space Activity Statistics . . . . . :
Data space size in bytes . . . . . . . : 282624
Physical file open accesses . . . . . . :
545,049
Physical file close accesses . . . . . :
544,909
Write operations . . . . . . . . . . . :
11
Update operations . . . . . . . . . . . :
10
Delete operations . . . . . . . . . . . :
Logical Reads . . . . . . . . . . . . . :
11,979,243,550
Physical Reads . . . . . . . . . . . . :
18,596,986
Clear operations . . . . . . . . . . . :
Data space copy operations . . . . . . :
Reorganize operations . . . . . . . . . :
Access paths builds/rebuilds . . . . . :
577
Records rejected by key selection . . . :
Records rejected by non-key selection . :
9,504,978,529
Records rejected by group-by selection. :
Access Path Activity Statistics . . . . . :
Access path logical reads . . . . . . . :
4,907,070,842
Access path physical reads . . . . . . :
Access path size . . . . . . . . . . . :
36864
Number of access path entries . . . . . : 1030
Access path valid . . . . . . . . . . . : Yes

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:24:40 Page 4

File . : VNDMST Library . : BIGLIB Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Member Description

Implicit access path sharing . . . . . : No
Access path journaled . . . . . . . . . : No
Last change date/time . . . . . . . . . . : 04/05/05
07:59:36
Extract date/time . . . . . . . . . . . . : 08/23/28
12:03:06
Last extract date/time . . . . . . . . . : 08/23/28
12:03:06
Last save date/time . . . . . . . . . . . : 04/06/05
18:24:37
Last restore date/time . . . . . . . . . : 10/11/03
03:27:11
Last used date . . . . . . . . . . . . . : 04/07/05
Days used count . . . . . . . . . . . . . : 547
Reset date . . . . . . . . . . . . . . :

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:24:40 Page 5

File . : VNDMST Library . : BIGLIB Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Record Format List

Record Format Level
Format Fields Length Identifier

VDMFMT 12 175 0811028083228
Text . . . :

Total number of formats . . . . . . . . . : 1
Total number of fields . . . . . . . . . . : 12
Total record length . . . . . . . . . . . : 175

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:24:40 Page 6

File . : VNDMST Library . : BIGLIB Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Member List

Source Creation Last Change
Deleted
Member Size Type Date Date Time
Records Records
VNDMST 319488 06/09/95 04/05/05 07:59:36
1030 256
Text: Vendor Master - PF

Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total records . . . . . . . . . . . . . . : 1030
Total deleted records . . . . . . . . . . : 256
Total of member sizes . . . . . . . . . . : 319488

New File (DSPFD)
--------------------------------------
5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:27:19 Page 1

File . . . . . . . . . . . : VNDMST
Library . . . . . . . . . : *LIBL
Type of information . . . . : *ALL
File attributes . . . . . . : *ALL
System . . . . . . . . . . : *LCL
Processor . . . . . . . . . : IBM AS/400 Display File Description
Processor

File . : VNDMST Library . : PRITCHARDC Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Data Base File Attributes

Externally described file . . . . . . . . . : Yes
File level identifier . . . . . . . . . . . :
1050407132216
Creation date . . . . . . . . . . . . . . . : 04/07/05
Text 'description' . . . . . . . . . . . . : TEXT Vendor
Master - PF
Distributed file . . . . . . . . . . . . . : No
DBCS capable . . . . . . . . . . . . . . . : No
Maximum members . . . . . . . . . . . . . . : MAXMBRS 1
Number of constraints . . . . . . . . . . . : 0
Number of triggers . . . . . . . . . . . . : 0
Number of members . . . . . . . . . . . . . : 1
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . . : RECOVER *AFTIPL
Force keyed access path . . . . . . . . . . : FRCACCPTH *NO
Member size SIZE
Initial number of records . . . . . . . . : 5000
Increment number of records . . . . . . . : 2000
Maximum number of increments . . . . . . : 3
Record capacity . . . . . . . . . . . . . . : 11000
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 *IMMED
Maximum record wait time . . . . . . . . . : WAITRCD 60
Max % deleted records allowed . . . . . . . : DLTPCT *NONE
Reuse deleted records . . . . . . . . . . . : REUSEDLT *NO
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 *MAX4GB
Maximum key length . . . . . . . . . . . . : 3
Maximum record length . . . . . . . . . . . : 175
File is currently journaled . . . . . . . . : No

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:27:19 Page 2

File . : VNDMST Library . : PRITCHARDC Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Access Path Description

Access path maintenance . . . . . . . . . . : MAINT *IMMED
Unique key values required . . . . . . . . : UNIQUE Yes
Access path journaled . . . . . . . . . . . : No
Access path . . . . . . . . . . . . . . . . : Keyed
Constraint Type . . . . . . . . . . . . . . : NONE
Number of key fields . . . . . . . . . . . : 1
Record format . . . . . . . . . . . . . . . : VDMFMT
Key field . . . . . . . . . . . . . . . . : VMVNO
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ *HEX

Language identifier . . . . . . . . . . . . : LANGID ENU

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:27:19 Page 3

File . : VNDMST Library . : PRITCHARDC Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Member Description

Member . . . . . . . . . . . . . . . . . . : MBR VNDMST
Member level identifier . . . . . . . . . :
1050407132216
Member creation date . . . . . . . . . . : 04/07/05
Text 'description' . . . . . . . . . . . : TEXT Vendor
Master - PF
Expiration date for member . . . . . . . : EXPDATE *NONE
Access path maintenance . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . : RECOVER *AFTIPL
Member size SIZE
Initial number of records . . . . . . . : 5000
Increment number of records . . . . . . : 2000
Maximum number of increments . . . . . : 3
Current number of increments . . . . . . : 0
Record capacity . . . . . . . . . . . . . : 11000
Current number of records . . . . . . . . : 0
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 *YES
Max % deleted records allowed . . . . . . : DLTPCT *NONE
Number of member accesses . . . . . . . . : 0
Data Space Activity Statistics . . . . . :
Data space size in bytes . . . . . . . : 8192
Physical file open accesses . . . . . . :
Physical file close accesses . . . . . :
Write operations . . . . . . . . . . . :
Update operations . . . . . . . . . . . :
Delete operations . . . . . . . . . . . :
Logical Reads . . . . . . . . . . . . . :
Physical Reads . . . . . . . . . . . . :
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 . . . . . . . :
Access path physical reads . . . . . . :
Access path size . . . . . . . . . . . :
8192
Number of access path entries . . . . . : 0
Access path valid . . . . . . . . . . . : Yes

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:27:19 Page 4

File . : VNDMST Library . : PRITCHARDC Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Member Description

Implicit access path sharing . . . . . : No
Access path journaled . . . . . . . . . : No
Last change date/time . . . . . . . . . . : 04/07/05
13:22:16
Extract date/time . . . . . . . . . . . . : 08/23/28
12:03:06
Last extract date/time . . . . . . . . . : 08/23/28
12:03:06
Last save date/time . . . . . . . . . . . :
Last restore date/time . . . . . . . . . :
Last used date . . . . . . . . . . . . . :
Days used count . . . . . . . . . . . . . : 0
Reset date . . . . . . . . . . . . . . :

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:27:19 Page 5

File . : VNDMST Library . : PRITCHARDC Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Record Format List

Record Format Level
Format Fields Length Identifier

VDMFMT 12 175 4F0433ECA7883
Text . . . :

Total number of formats . . . . . . . . . : 1
Total number of fields . . . . . . . . . . : 12
Total record length . . . . . . . . . . . : 175

 5722SS1 V5R2M0 020719 Display File Description
4/07/05 13:27:19 Page 6

File . : VNDMST Library . : PRITCHARDC Type of file . :
Physical *DATA Auxiliary Storage Pool ID . : 01

Member List

Source Creation Last Change
Deleted
Member Size Type Date Date Time
Records Records
VNDMST 16384 04/07/05 04/07/05 13:22:16
0 0
Text: Vendor Master - PF

Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total records . . . . . . . . . . . . . . : 0
Total deleted records . . . . . . . . . . : 0
Total of member sizes . . . . . . . . . . : 16384

[GB]

The file level id is based on the creation date & time. It only comes into
play when doing restores.

The record level identifier (RLI) is what cause "level checks". the RLI is
derived from the the field names, lengths, datatypes and the format name.

So to put it simply, your source doesn't match your object...

So how to find the difference?

Compile the source that you have into another library, execute a DSPFFD on
the old & new files.

Compare: format names
field names
field lengths
field decimal places
data type (packed, decimal etc.)

There is a difference somewhere...

If you don't find it, cut & paste the two DSPFFD outputs and let us all have
a look...

HTH

GB

<copr...@gmail.com> wrote in message
news:1112887598.1...@z14g2000cwz.googlegroups.com...

[Denny Davis]

I am comming into this posting late, but both the original and new
file specify Record format level check .. . . . . : LVLCHK *NO

So you would not have gotten any level check errors using the
original.

You could alway do a crtdupobj or cpyf create(*yes) to create an exact
duplicate.

There must be something different at the field level to cause the
different record format level check id.. The file level id is not
relavent.

Denny

[SamL]

A couple of years ago we did a CRTDUPOBJ on PF-38 that hadn't be changed for
years and the record format level changed in the new object. We argued with
IBM and lost. As I recall, it appeared that there was some obscure bug that
kicked in when the file was originally created and when fixed it "broke" our
file. The exact nature eludes me but IBM, I believe, "clarified" the
documentation somewhere.

I haven't run into it with CRTPF though.

Sam
<copr...@gmail.com> wrote in message
news:1112891864.1...@f14g2000cwb.googlegroups.com...

[Jonathan Bailey]

You also have to check the CCSID on every field. Our place has
development & production systems set differently so if you generate a
copy of a file in the prod system you often get this error.

Jonathan