Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103

    Unanswered: DB21018E A system error occurred

    Wanted to create two indexes in parallel in two different tables so tried the following

    q1.sql (file has the following contents)
    connect to db;
    create index i1 on t1(c1);

    q2.sqlfile has the following contents)
    connect to db;
    create index i1 on t1(c1);

    run.ksh(script has the following contents)
    nohup db2 -tvf q1.sql &
    nohup db2 -tvf q2.sql &

    When executed as run.ksh > run.ksh.out it produces the following
    DB21018E A system error occurred. The command line processor could not
    continue processing.
    DB21018E A system error occurred. The command line processor could not
    continue processing.

    What is the cause of this ? Env: AIX 5.3/DB2 9.1/Korn Shell

  2. #2
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103
    Typo error earlier:
    q2.sql (file has the following contents)
    connect to db;
    create index i2 on t2(c1);

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I've simplified it a bit:

    Script run.ksh contains:
    nohup db2 -tvf q1.sql &


    q1.sql contains:
    connect to test;


    The script will generate the error mentioned above, DB21018E


    If I execute "nohup db2 -tvf q1.sql &" from the command line, then it works ok.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Modified run.ksh to have:
    nohup db2 &


    This modified script also generates DB21018E, but the command executes ok from the command line.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    The following works:

    Using two scripts

    run.ksh.b contains:
    run.ksh.a &


    run.ksh.a contains:
    nohup db2 -tvf q1.sql
    nohup db2 -tvf q2.sql

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •