Importing GEN Database

Use this procedure to load the data from the 9.0.1 GEN database.

Import GEN data

  1. Copy the 9.0.1.x GEN dictionary to the LADB directory. At the command line, type

    cp $LAWDIR/temp901/GEN901 $LADBDIR/dict

  2. In the 10.0.x Environment, verify that the job queue is stopped. At the command line, type

    stopjobqueue

  3. Import the GEN database files.
    Note:  When running the dbcopy command, be sure to specify only the files that are listed in the command below. If you unintentionally included additional files in the export to gen901wk, importing the additional files may cause serious issues and you may need to restart the upgrade process.

    At the command line, type

    dbcopy -cfit -S $LAWDIR/temp901/gen901wk gen901 gen user userinfo dstgrp dstgrpdtl dstgrpgrp dstgrpuser exerpt printer prtgrp prtgrpdtl usergrp usergrpdtl calendar calyear usermenu job jobqdflt jobqgrp jobqgrpdtl jobqueue jobstep jobsteprpt jobstepwrk recurjob queuedjob userrpt

  4. If the name of the 10.0.x application product line will be different than the name of the 9.0.1.x application product line, modify the application product line values in the jobstep and queuedjob files.

    For example, using SQL statements, where gendb10 is the SQL schema name for the GEN product line, LAWAPP10 is the name of your application product line in the 10.0.x Environment, and LAWAPP9 is the name of the application product line in the 9.0.1.x Environment:

    update gendb10.jobstep set productline = 'LAWAPP10', project ='LAWAPP10' where productline='LAWAPP9' and project='LAWAPP9'

    update gendb10.queuedjob set productline = 'LAWAPP10' where productline='LAWAPP9'