DSXchange

<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.

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.

What is your job design?

[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

Take a look at the file /aihome/routhu/msg10. It should have some informational/error messages to help you debug the error.

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.