Re: V2R3 CISC to V4R2 RISC - Do we dare?

[Pete Massiello <pmassiello@xxxxxxxxxxxxxxxx>]

Rob Berendt wrote:
> 
> We haven't done the V2R3 to V4R2.  We've done V3R2 to V4R2.  Follow the steps 
>of the 'Roadmap for changing to Power PC technology' very carefully.  Since 
>we've done many CISC-to-RISC upgrades we have our own instructions written 
>down that go along with the book.  Our instructions are tailored for the 
>individual machine, and the upgrade path chosen.  For example:  side-by-side, 
>unload/reload, etc.
> 
> 
>  gone by, that the dependence has grown on these files and I would be loathe 
>to delete them.
> 
> Check this out:
>  Library     Object      Object           Object   Text description
>                          Type             Size
>  QSYS        QADBIFLD    *FILE     1,674,665,984   Cross reference physical 
>file
>  QSYS        QADBIATR    *FILE       190,861,312   Cross reference logical 
>file
>  QSYS        QADBILFI    *FILE       171,986,944   Cross reference logical 
>file
>  QSYS        QADBILLB    *FILE       110,145,536   Cross reference logical 
>file
>  QSYS        QADBXREF    *FILE        48,410,624   Cross reference physical 
>file
>  QSYS        QADBKFLD    *FILE        47,239,168   Cross reference physical 
>file
>  QSYS        SSA         *USRPRF      45,129,728   Group profile for BPCS
>  QSYS        QADBFDEP    *FILE        16,830,464   Cross reference dependency 
>fi
> 
> Whenever you use the SQL command CREATE COLLECTION to build a library it will 
>build logical files over these physicals and store them in the new library you 
>created.

Rob,

  I dont know if you can permenantly delete them. I beleive that you
will run into trouble.  THis files get full of deleted records, and you
need to bring the system into a restricted state to reorg them using an
IBM program by doing CALL QDBRCLXR or for those on V4R2 RCLSTG 
SELECT(*DBXREF).  Everytime you do a restore, rename, create of files
this cross reference files get updated.  THis functionality was added to
all OS/400 levels starting with V3R1.

  I dont know why you have the SSA *USRPRF in that list above. If you
are wondering why it is so big, it because it probably owns all your
BPCS objects.

   

-- 
Pete Massiello
OS Solutions International 
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---