Unable to access partitioned DB2 table with Enterprise Stage

[StefL]

We're in the process of creating a number of jobs writing fairly large amounts of data to DB2. Thus we're implementing a partitioned table structure with the intention of distributing the tables across several tablespaces. That is, the tables will be range partitioned in addition to regular (?) partitioning, to allow for data to be spread in different partitions depending on date for instance (that is, one date per partition).
We're facing a somewhat odd error - when having created a table in the database, being able to see it through normal client tools, Data Stage is unable to find it.
Running a job that is to write to the table returns the error:
"main_program: Fatal Error: Table `table_name' must exist before querying the node group."
That is, the table is there but the Data Stage DB2 Enterprise Stage is unable to find it.
When trying to do a read towards the table we're able to see the table using either an API Stage or using the Enterprise Stage with Read Method 'Auto Generated SQL' instead of 'Table'. (Read Method 'Table' returns the same error as mentioned above).
Writing to the table using Enterprise Stage however seems futile...

We're unable to say preciesly whether this is a DB2 or a Data Stage error. Furthermore, we've had some issues regarding versions to be able ro run the Enterprise Stage towards DB2 v9 which we're using to be able to utilise partitioning fully.
The original Data Stage version of 7.5.1 had to be upgraded to 7.5.2 plus have a patch applied, which according to IBM does allow running the Enterprise stage against a v9 partitioned DB2 database (although the official policy is that you need to upgrade to DS v8 which is honestly not really an option just yet...).
We have done this upgrade to 7.5.2 plus patch on the server but the clients are still 7.5.1. We have been led to believe though that the compatibility with DB2 v9 is only a compiler thing so it really shouldn't matter on the client.

[s_boyapati]

Do you have location of db2nodes.config file part of PATH and LIBPATH in dsenv file? ?( not sure but definitely either PATH or LIBPATH) If not you will receive this mesage. If you have, you need to check your licensing of DataStage to work with DB2. (DB2 DPF with multiple nodes on different boxes demands more licenses on DataStage to share/mount datastage directories on all nodes). I faced the same problem when using DB2 enterprise stage with DB2 DPF.

Sree

[us1aslam1us]

why are you copying whole message from the OP while replying. Please restrain from doing that as it will take the server space and you will get some good advices from the Moderators.

Sam