Topic
  • 3 replies
  • Latest Post - ‏2012-05-21T13:35:17Z by chandroo
lpadrta
lpadrta
3 Posts

Pinned topic IIS 8.5 - DB2 Connector Bulk Load

‏2011-05-10T13:51:45Z |
Using IIS 8.5 on linux, loading into DB2 9.7 on linux

I'm trying to use the DataStage DB2 Connector's bulk load option to load a 10 partition target table (as told by the local db2 dba) on linux. I'm using a 10 node DataStage parallel configuration file (based on 2 actual mount points), and from reading the Director logs, I'm getting 10 partitions in the DataStage job. It's generating the db2 insert statement and connecting to the db2 server, but it appears that I'm not connecting to the db2 table partitions to perform the load action. I've reviewed the configuration of the stage with the local dba, and I think we should have the stage configured OK, but it isn't working.

Following are error messages:

IIS-DSEE-TFPM-00192 node_dev0node1: Player 4 terminated unexpectedly.

IIS-DSEE-TFPM-00338 main_program: APT_PMsectionLeader(1, dev0node1), player 4 - Unexpected exit status 1.
APT_PMsectionLeader(1, dev0node1), player 2 - Unexpected exit status 1.
APT_PMsectionLeader(1, dev0node1), player 3 - Unexpected exit status 1.
APT_PMsectionLeader(2, dev0node2), player 2 - Unexpected exit status 1.
APT_PMsectionLeader(2, dev0node2), player 3 - Unexpected exit status 1.
APT_PMsectionLeader(1, dev0node1), player 6 - Unexpected exit status 1.
APT_PMsectionLeader(2, dev0node2), player 5 - Unexpected exit status 1.
APT_PMsectionLeader(5, dev1node3), player 5 - Unexpected exit status 1.
APT_PMsectionLeader(1, dev0node1), player 7 - Unexpected exit status 1.
APT_PMsectionLeader(5, dev1node3), player 6 - Unexpected exit status 1.
APT_PMsectionLeader(4, dev1node2), player 5 - Unexpected exit status 1.
APT_PMsectionLeader(4, dev1node2), player 6 - Unexpected exit status 1.
APT_PMsectionLeader(3, dev1node1), player 5 - Unexpected exit status 1.
APT_PMsectionLeader(3, dev1node1), player 6 - Unexpected exit status 1.

IIS-DSEE-TFSC-00011 main_program: Step execution finished with status = FAILED.

When I changed the DataStage job to use a 2 node configuration file, I got the following error message:

IIS-CONN-DB2-00369 DB2Update: Error in environment configuration: The target table has 5 partitions but the environment configuration has 2 node(s) available. Make sure there are at least 5 nodes in your environment configuration. It is required that the number of nodes in the environment configuration be greater than or equal to the number of database table partitions when the partitioner is set to DB2 Connector or when using the bulk load write mode with more than one node in the environment configuration. (CC_DB2Connection::assignPartNumsToEnvironmentNodes, file CC_DB2Connection.cpp, line 2,506)

The config files have two mount point nodes that are invoked to create the 10 node config file.

>>> Does this indicate that there must be at least 5 (or 10) mount point nodes specified in the config files to load a 10-partition table in db2 using the DB2 Connector Bulk Load mechanism? Or am I missing something else, maybe?

Thanks,
Lynda
Updated on 2012-05-21T13:35:17Z at 2012-05-21T13:35:17Z by chandroo
  • lpadrta
    lpadrta
    3 Posts

    Re: IIS 8.5 - DB2 Connector Bulk Load

    ‏2011-05-19T12:34:50Z  
    We will be installing Fix Pack 1.
  • lpadrta
    lpadrta
    3 Posts

    Re: IIS 8.5 - DB2 Connector Bulk Load

    ‏2011-08-18T15:15:28Z  
    • lpadrta
    • ‏2011-05-19T12:34:50Z
    We will be installing Fix Pack 1.
    FixPack 1 appears to have fixed the problem.
  • chandroo
    chandroo
    1 Post

    Re: IIS 8.5 - DB2 Connector Bulk Load

    ‏2012-05-21T13:35:17Z  
    • lpadrta
    • ‏2011-08-18T15:15:28Z
    FixPack 1 appears to have fixed the problem.
    Hi Team

    Using 4 node and single mount point.

    In Staging Area, i want to use the BULK LOAD OPTION

    DB2_Connector_32: The connector was not able to obtain partitioning information for the table ora_stg.PA_PROJ_ELEMENTS in the database INFRADB. The method sqlugtpi returned reason code 0, SQLCODE -303. Ensure that the table exists and that it can be accessed. (CC_DB2Connection::obtainPartitioningInfoForTable, file CC_DB2Connection.cpp, line 2,292)

    GETTING THIS ERROR.. IF I DO THE INSERT THEN ITS INSERTION CAN BE DONE.. BUT I FAIL IN BULK LOAD OPTION.

    CAN ANYONE GUIDE ME HOW TO IMPLEMENT THE BULK IN DB2 CONNECTOR STAGE..