DSXchange

You post heading is so tragic :shock: ... Sorry :) What is the criteria to set DISKCACHE and DCBLOCKSIZE? # DISKCACHE - Specifies the state of the DISKCACHE subsystem. # Valid values are the following: # 0 = REJECT, DISKCACHE is inactive # and files opened in READONLY or WRITECACHE mode # will give...

I have 2 DataStage Servers, Server1 and Server2. Server1 needs to die :shock: and I need to put and make work all the Server1's project into Server2. I'm comparing TNS, DB2 Catalog, tree of directories, ... I know that to work they need to have their uvconfig file changed. Today both work, in separa...

ray.wurlod wrote:Use categories. Segregate the parallel jobs using categories. Export only those categories.

You can drag/drop jobs between categories - you could even restore them to their original locations lat ...

Thanks,

Fernando

I have 350 jobs in my project. 70 parallel and 280 others. I need to generate a ".dsx" with only the parallel jobs. What is the best way to do this? I know that I can generate by Manager, but is very hard append 1 by 1. I there any DataStage Administrator command, TCL prompt, that can I do...

ray.wurlod wrote:1. 32-bit.

2. It's quicker to truncate. And the permissions required are different.

3. When you choose DB2 partitioning algorithm there is a tool to the right of the drop-down list, which opens ...

Thanks

vij wrote:can I access a particular job in mutiple designers? pls let me know how to do it?

Open the same job in mutiple designers, this is not possible yet.

Fernando

Hi, I'm trying to use the DB2\UDB Enterprise Stage but I'm having some doubts: Scenario: - My DB2 is 8.1 ESE with the DPF(database partitioning feature) must be installed. - The target table isn't partitioning. - The database DB2 is 64 bits. - The datastage server and database server are differents ...

DataStage is a 32-bit application. The database can be either 32-bit or 64-bit, but DataStage must find the 32-bit libraries for accessing the database; that is, the 32-bit libraries must occur befor ... Ray, looking the help I saw that DB2/UDB Enterprise Stage needs the following requirements to w...

The stage goes to DB2 and checks the partitioning of the table whose name you supply via the tool to the right of the partitioning algorithm. Make sure that an appropriate table name is given (typica ... Talking with the DBA he told me: There isn't anything partitioned in the database, what exist i...

Have you had a chance to check your dsenv file yet? You may need to work with whomever is your DataStage administrator (or whomever has admistrative rights to update this file). I think the first step of fixing your issue is making sure the right instance is referenced. Let us know what happens whe...

kris007 wrote:Did you meet the requirements for using a LOAD stage such as setting Non-Recoverable Transactions as TRUE and giving the path for a local message file.

I don't know if I understand, but I'm using a "DB2/UDB Enterprise Stage" with write method = "load"

Was that the full fatal error message? Don't you get more info if you double click the log event? ... Full error message: -> DB2 Load Binary Error -> SQLCODE = -27959; SQLSTATE= /datastage/scratch/ordb21880090bd8bd084_ -> SQL27959N The partitioned database configuration option "PARTITIONED DB ...

What are the error messages that you are getting? ... 1 - warning -> The enviroment variable DB2INSTANCE is currently set to db2inst1 2 - Fatal -> Error Idx = 1; (...) Good points: a - the real name of the DB2 intance is "ipi03" but when was made the catalog in data stage server was named...

My source is a file and my target is a DB2/UDB(UNIX AIX).

When I use the write mode works, but when I use the load mode don`t work.

Does anyone can help me?

Regards,

Fernando

I need to read from a sequential file and insert in a db2 table.

What is better to use in the target "DB2 Bulk Loader" or "DB2/UDB stage"
?

Regards,

Fernando