If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB21018E A system error occurred

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-11-09, 15:47
db2udbgirl db2udbgirl is offline
Registered User
 
Join Date: Mar 2006
Location: Tuticorin, India
Posts: 100
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
Reply With Quote
  #2 (permalink)  
Old 09-11-09, 15:49
db2udbgirl db2udbgirl is offline
Registered User
 
Join Date: Mar 2006
Location: Tuticorin, India
Posts: 100
Typo error earlier:
q2.sql (file has the following contents)
connect to db;
create index i2 on t2(c1);
Reply With Quote
  #3 (permalink)  
Old 09-11-09, 17:35
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
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.
Reply With Quote
  #4 (permalink)  
Old 09-11-09, 17:46
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Modified run.ksh to have:
nohup db2 &


This modified script also generates DB21018E, but the command executes ok from the command line.
Reply With Quote
  #5 (permalink)  
Old 09-11-09, 18:59
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On