DSXchange

Hi,

I've seen a XML2DSX application in the InformationServer\Clients\Classic folder that could help you to convert your jobs.

Let us know if it does the job.

Regards,
Eric

Hi, I'm in the process of automate job comparison and I plan to use diffapicmdline to generate reports. I got the following error and nothing is generated after : Validating syntax of /lhscd. Validating syntax of /rhscd. Preparing Items Jx_BO_DIM_Chargement_Init_Prev_002_PC and Jx_BO_DIM_Chargement_...

Hi,

You can run uv queries using uvsh command line tool.

Assuming that you have an sqlplus like app, with the correct credentials, it is possible to run quite the same query with the xmeta repository (if you're using an Oracle repository).

Regards,
Eric

The first time I saw it was on dsxchange

Then I found it in a pdf, but I can't recall its name (one about job sequence).

You can find more info on IBM' website

Regards,
Eric

Hi,

Is the content of the command line (except passwords) mandatory in the log?

If not, you can use the /NOLOG/ option in the EC activity.

Regards,
Eric

Hi,

I personally use orchdbutil via execute command activity plus a server job to beautify the result before loading data. I guess it's the best way if you want something dynamic.

Regards,
Eric

Hi, I don't know if I'm off-topic but could this be related to a wrong parameter value in the uvconfig file? Previously I got trouble with the number of opened file descriptors (DS could open as many as the OS permitted). Then I changed values in the uvconfig according to IBM's proposal and get it w...

Hi, As I've seen, it's a zip containing xml exports. The odd thing is that this xml export is different from the Desiner one (xml not formated with the same xml tags). From my experience, I got less problems with isx than dsx, at least for huge exports (whole projet in one file). One can also use th...

Hi! Following qt_ky's idea, after a generation of all job's report, it's quite easy to parse the results into a csv First step : Generate the documentation using DsJobReport (cf Kim Duke's website) Then execute the following script on unix shell, using the job sequence naming convention (like Jq_, S...

Hi, You need to use your DataStage installation's compiling options, which are located in the administrator as APT_COMPILEOPT environment variable (for me it's g++34 -O -fPIC -Wno-deprecated -c -m32 ). I suggest you to take a look at this post : http://it.toolbox.com/blogs/dw-soa/datastage-parallel-...

Hi,

Have you tried column export in which you could concatenate your 200 fields' content in one particular field?

Eric

For information,

I get the same kind of behavior using an Oracle Enterprise to retrieve data (getting a "table or view does not exists"), and the job abort in some cases, but mostly continues and finish, even with this "Fatal" error.

Eric

Hi all, I'm running an Oracle Connector stage with bulk load to a table passed in a parameter as following: #SCHEMA#.#TABLE#. All inserts and selects made on the database use that schema as part of the sql instruction, but the rebuild index is not using it. Oracle traces are as follow: bpopsgl1_ora_...

Hi all, I'm facing a strange situation using an Oracle Connector to extract data (simple select on table) compared to the same job using an old-fashion Oracle Enterprise. Using the same NLS map (Project default = UTF-8), the Oracle connector fails with the error messages below, while the Oracle Ente...

As a conclusion to this thread, I've decided to higher up the number of jobs that can be run in parallel from 40 to 70. As mentioned, the new parameters have enable our DS installation to perform more jobs in parallel, but after a second test on a more complex job, we've reached the physical limits ...