<UDBDB2STAGE>,0: DB2 Load Binary Error.
<UDBDB2STAGE>,0: SQLCODE = -27959; SQLSTATE= <DSScratchpath>/ordb2195388278623545_
<UDBDB2STAGE>,0: SQL27959N The partitioned database configuration option "PARTITIONED DB CONFIG" is invalid. Reason code = "1".
<UDBDB2STAGE>,0: Failed opening fifo <DSScratchpath>/ordb2195388278623545_.000 after 90 seconds: No such device or address.
<UDBDB2STAGE>,0: Errors during load (child returned 2); please examine the file /aihome/routhu/msg10.
<UDBDB2STAGE>,0: The runLocally() of the operator failed.
I am getting above error when performing load with truncate option on target db2 table with DB2UDB stage.
Have any body seen this error before. Please help.
I am loading data from unpartitioned database to partitioned database. It is the same table I am extracting from one database(unpartitioned) and loading into the same table in another database(partitioned).
PLEASE HELP.
Thanks in advance.
<UDBDB2STAGE>,0: DB2 Load Binary Error.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Wed Oct 10, 2007 7:34 am
Re: <UDBDB2STAGE>,0: DB2 Load Binary Error.
What is your job design?vikki_routhu@yahoo.co.uk wrote:<UDBDB2STAGE>,0: DB2 Load Binary Error.
<UDBDB2STAGE>,0: SQLCODE = -27959; SQLSTATE= <DSScratchpath>/ordb2195388278623545_
<UDBDB2STAGE>,0: SQL27959N The partitioned database configuration option "PARTITIONED DB CONFIG" is invalid. Reason code = "1".
<UDBDB2STAGE>,0: Failed opening fifo <DSScratchpath>/ordb2195388278623545_.000 after 90 seconds: No such device or address.
<UDBDB2STAGE>,0: Errors during load (child returned 2); please examine the file /aihome/routhu/msg10.
<UDBDB2STAGE>,0: The runLocally() of the operator failed.
I am getting above error when performing load with truncate option on target db2 table with DB2UDB stage.
Have any body seen this error before. Please help.
I am loading data from unpartitioned database to partitioned database. It is the same table I am extracting from one database(unpartitioned) and loading into the same table in another database(partitioned).
PLEASE HELP.
Thanks in advance.
-
- Participant
- Posts: 3
- Joined: Wed Oct 10, 2007 7:34 am
Re: <UDBDB2STAGE>,0: DB2 Load Binary Error.
[quote="Havoc"][quote="vikki_routhu@yahoo.co.uk"]<UDBDB2STAGE>,0: DB2 Load Binary Error.
<UDBDB2STAGE>,0: SQLCODE = -27959; SQLSTATE= <DSScratchpath>/ordb2195388278623545_
<UDBDB2STAGE>,0: SQL27959N The partitioned database configuration option "PARTITIONED DB CONFIG" is invalid. Reason code = "1".
<UDBDB2STAGE>,0: Failed opening fifo <DSScratchpath>/ordb2195388278623545_.000 after 90 seconds: No such device or address.
<UDBDB2STAGE>,0: Errors during load (child returned 2); please examine the file /aihome/routhu/msg10.
<UDBDB2STAGE>,0: The runLocally() of the operator failed.
I am getting above error when performing load with truncate option on target db2 table with DB2UDB stage.
Have any body seen this error before. Please help.
I am loading data from unpartitioned database to partitioned database. It is the same table I am extracting from one database(unpartitioned) and loading into the same table in another database(partitioned).
PLEASE HELP.
Thanks in advance.[/quote]
What is your job design?[/quote]
I am using Parallel job.
DB2/UDB stage(source)-----> DB2/UDB stage(target)
No transformations. As I said source is unpartitioned and target is partitioned
<UDBDB2STAGE>,0: SQLCODE = -27959; SQLSTATE= <DSScratchpath>/ordb2195388278623545_
<UDBDB2STAGE>,0: SQL27959N The partitioned database configuration option "PARTITIONED DB CONFIG" is invalid. Reason code = "1".
<UDBDB2STAGE>,0: Failed opening fifo <DSScratchpath>/ordb2195388278623545_.000 after 90 seconds: No such device or address.
<UDBDB2STAGE>,0: Errors during load (child returned 2); please examine the file /aihome/routhu/msg10.
<UDBDB2STAGE>,0: The runLocally() of the operator failed.
I am getting above error when performing load with truncate option on target db2 table with DB2UDB stage.
Have any body seen this error before. Please help.
I am loading data from unpartitioned database to partitioned database. It is the same table I am extracting from one database(unpartitioned) and loading into the same table in another database(partitioned).
PLEASE HELP.
Thanks in advance.[/quote]
What is your job design?[/quote]
I am using Parallel job.
DB2/UDB stage(source)-----> DB2/UDB stage(target)
No transformations. As I said source is unpartitioned and target is partitioned
-
- Participant
- Posts: 3
- Joined: Wed Oct 10, 2007 7:34 am
For some reason, that msg10 file is not getting created. I searched while executing, using tail -f msg10. I don't know why it is not creating message file in my home directory.
I did noticed one thing, that I want to share: when I set "Cleanup on failure" option to true, it ran with out any error but with warning, but it didn't load data in the target table.
Thanks for your help.
I did noticed one thing, that I want to share: when I set "Cleanup on failure" option to true, it ran with out any error but with warning, but it didn't load data in the target table.
Thanks for your help.