DSXchange

We have weekly backups of our DataStage enviroments - XMETA database, WAS, etc. But this requires downtime. We would like to do daily online backups to guard against loss of work, espeically in development. One option we are considering is simply identifying projects or jobs that have changed and us...

We have AIX at our shop (large IBM servers). Works great, but very expensive. I have been hearing rumors that our corporate infrastructure teams are being encouraged to migrate from AIX to Linux.

Brad.

By the way, we did run into one issue/bug. The client (local) DB2 instance was a different version than the server (remote) instance, and so we had to explicitly set the DB2INSTANCE environment variable to point to the remote instance. We brought this up as an issue with IBM because other DB2 stages...

When we talked to IBM, they said it was a known issue and sent us a custom 'db2part' operator with the necessary options. If you talk to IBM, the PMR we used is 34835,370,000.

Brad.

We process several terabytes a day (reading, writing, etc.), with tight timelines and so have used the previously stated "one-size-fits-all approach", knowing that it is overkill in some instances. The sheer volume of the conversion forced us this direction, but now we are needing to rethi...

We just finished a conversion from DS7.5 to Ds8.1, and DB2 to Teradata. We are now running Ds8.1 against TD13. There are approx 6K jobs and about 45% of them touch Teradata. To simplify the conversion effort, we have been using a one-size-fits-all approach and using 16 sessions per TD stage/connecto...

Our Infrastructure group is looking into this. One of the qeustions that came up is whether DB2 Connect can be setup on a client instance or if it can only be used on a server instance. Our own UDB is on a remote server, so our ETL server has a local client instance and the database is cataloged on ...

By the way, we have 2 sets of scratch disk defined on our system. The first is 100GB of RAM disk (i.e. it is memory mapped to a filesystem, so really fast). The 2nd is a regular 500GB filesystem. If the first fills up, jobs automatically start using the 2nd. We saw upwards of a 50-60% effciency incr...

Well, I think you have kind of answered your own question. It is temporary storage space for stages like sort, aggreator, etc. The scratch space is partitioned just like your datasets, so each node has space for work. Databases do teh same thing with temp space. I think the engine uses this space to...

When you import your data, do you need the field to maintain formatting (i.e. keep the carriage retruns) or ignore them?

Brad.

Has anyone used the DB2z stage before to talking to a mainframe-based DB2 database? We are running from Unix using DataStage 8.1 talking to DB2 OS/390 9.1.5 on the mainframe I am getting the following error message in DataStage: main_program: Qualified table name : DT3G.COMM_METHOD_TB. Resource bund...

Has anyone used a DB2 partitioner before against a remote database? It does not have options (in the GUI) to se username and password, so how do you set it up? We did discover that the OSH has those parameters, but for some reason they were left out of the stage in the GUI. Makes no sense...

Brad.

May have been a bad example, but that is the gist of over-partitioning, right?

Not to get distracted, but when you say orchadmin is not installed right or not working, are you getting library errors? Something like this: exec(): 0509-036 Cannot load program orchadmin because of the following errors: 0509-150 Dependent module /opt/CA/UnicenterAutoSysJM/autosys/lib/libicui18n.a ...

* What database are you coming from? * How is the data being read from the database? (SQL, table read, etc.) * How is the field defined in the database? * Have you confirmed that the data is stored in teh dataset as nullable? (Note: I like to look at the dataset on the server itself and check its sc...