VERIFIED SOLUTION i

Error "File Status 04" when installing the CODE-1 Plus US Postal database on the IBMi platform

Products Affected:  CODE-1 Plus
Operating System: IBMi, iSeries
 

Issue

The CODE-1 Plus US Postal database has been downloaded and the tapblk01.cd file FTP'd to the IBMi machine as Binary.  At installation time, "File Status 04" is generated.  

Cause

CODE-1 Plus delivers a G1FILE when the software is installed.  If this file is deleted at any point and subsequently re-created, this error indicates the G1FILE was created with an incorrect record length or maximum member allocation. The delivered G1FILE with the CODE-1 Plus install has the correct options.

Resolution

UPDATED: July 5, 2019
Below is the delivered G1FILE attributes that can be used as a template.  See record length and maximum member allocation:

DSPFD Command Input
  File  . . . . . . . . . . . . . . . . . . . : FILE       G1FILE
    Library . . . . . . . . . . . . . . . . . :            G1C1PGMS
  Type of information . . . . . . . . . . . . : TYPE       *ALL
  File attributes . . . . . . . . . . . . . . : FILEATR    *ALL
  System  . . . . . . . . . . . . . . . . . . : SYSTEM     *LCL
File Description Header
  File  . . . . . . . . . . . . . . . . . . . : FILE       G1FILE
  Library . . . . . . . . . . . . . . . . . . :            G1C1PGMS
  Type of file  . . . . . . . . . . . . . . . :            Physical
  File type . . . . . . . . . . . . . . . . . : FILETYPE   *DATA
  Auxiliary storage pool ID . . . . . . . . . :            00001
Data Base File Attributes
  Externally described file . . . . . . . . . :            No
  File level identifier . . . . . . . . . . . :            1110301231418
  Creation date . . . . . . . . . . . . . . . :            03/01/xx
  Text 'description'  . . . . . . . . . . . . : TEXT
  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
   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   *NO
   Coded character set identifier  . . . . . . : CCSID      65535
   Allow read operation  . . . . . . . . . . . :            Yes
   Allow write operation . . . . . . . . . . . :            Yes
   Allow update operation  . . . . . . . . . . : ALWUPD     *YES 
   Allow delete operation  . . . . . . . . . . : ALWDLT     *YES
   Record format level check . . . . . . . . . : LVLCHK     *YES
   Access path . . . . . . . . . . . . . . . . :            Arrival
   Maximum record length . . . . . . . . . . . :            24576
   File is currently journaled . . . . . . . . :            No
Access Path Description
   Access path . . . . . . . . . . . . . . . . :            Arrival
   Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ     *HEX
   Language identifier . . . . . . . . . . . . : LANGID     ENU
Member Description
   Member  . . . . . . . . . . . . . . . . . . : MBR        G1FILE
     Member level identifier . . . . . . . . . :            1110301231418
     Member creation date  . . . . . . . . . . :            03/01/xx
     Text 'description'  . . . . . . . . . . . : TEXT
     Expiration date for member  . . . . . . . : EXPDATE    *NONE
     Member size . . . . . . . . . . . . . . . : SIZE       *NOMAX
     Current number of records . . . . . . . . :                 47880
     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
     Data Space Activity Statistics  . . . . . :
       Data space size in bytes  . . . . . . . :         1193328640
       Physical file open accesses . . . . . . :                            24
       Physical file close accesses  . . . . . :                            24
       Write operations  . . . . . . . . . . . :                     1,178,704
       Update operations . . . . . . . . . . . :
       Delete operations . . . . . . . . . . . :
       Logical Reads . . . . . . . . . . . . . :                         1,936
       Physical Reads  . . . . . . . . . . . . :                         1,243
       Clear operations  . . . . . . . . . . . :                             5
       Data space copy operations  . . . . . . :
       Reorganize operations . . . . . . . . . :
       Access paths builds/rebuilds  . . . . . :
       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  . . . . . . :
       Implicit access path sharing  . . . . . :            No
     Last change date/time . . . . . . . . . . :            01/29/xx  21:52:29
     Last save date/time . . . . . . . . . . . :            01/10/xx  19:57:05
     Last restore date/time  . . . . . . . . . :            05/22/xx  12:22:41
     Last used date  . . . . . . . . . . . . . :            01/30/xx
     Days used count . . . . . . . . . . . . . :                3
       Reset date  . . . . . . . . . . . . . . :
     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  . . . . . . . . . . . . . . :                             
Record Format List
                        Record  Format Level
  Format       Fields   Length  Identifier
  G1FILE            1    24576  2DB72C146D778
    Text . . . . . . . . . . . . . . . . . . . :
  Total number of formats  . . . . . . . . . . :           1
  Total number of fields . . . . . . . . . . . :           1
  Total record length  . . . . . . . . . . . . :       24576
Member List
                              Source Creation    Last Change                  Deleted
  Member           Size        Type  Date       Date     Time      Records    Records
  G1FILE           1193328640        03/01/xx 01/29/xx 21:52:29      47880          0
    Text:
  Total number of members  . . . . . . . . . :                 1
  Total number of members not available  . . :                 0
  Total records  . . . . . . . . . . . . . . :             47880
  Total deleted records  . . . . . . . . . . :                 0
  Total of member sizes  . . . . . . . . . . :        1193328640