DSXchange

Are you aware of existing references I could use to build that script ?

Is there a way to generate all reports for all tables and all types of analysis in a single operation ? Is there command lines or Profile Stage functionnality that would allow that automatisation ?

This is a DataStage Admins responsibility but here is what I would do: 1. Execute a ps -ef | grep -I pha to determine if any phantom Server Jobs are running. 2. If there are phantoms then do a kill -9 on them. 3. Once this is done then stop the DataStage. Thank you Ted for your help ! I searched fo...

kcbland wrote:Check your DS project's file system to make sure you're not out of space. If nothing runs, that's usually the first issue. Next, verify that userids/permissions haven't changed on the project/jobs.

Both things are OK....

Could it be DataStage that needs to be re-Index ?

Thanks for your help !

Hi, Since yesterday, for all jobs I'm running (regarless of if it is Server or PX, access the BD or not), I'm getting the following errors : Log as Info : Contents of phantom output file => start problems or Log as Warning : start problems DataStage Job 635 Phantom 30268 DataStage Phantom Finished I...

Hi, I installed QS 7.0. When I'm running CASS from a PX job and I'm getting these warnings below telling that some files are not found. I checked, the files are not on the installation disk or somewhere else on the server. Were could I found these missing files ? - recpnt.ucl - urb.ucl - gus_rz.ucl ...

Hi,

I'm running CASS as Before-job Subroutine in a PX job.

pacez -i #inputFile# -o #outputFile# -f #controlFile# -s #inputRecordLength# -S #outRecordLength#

The performance is not good, for 6000 records it takes around 4 minutes... does anyone know how to improve it ?

Thanks,

Isabelle

Hi,

Is there a way with PX to split a file in as many files as needed considering that there each file has a limit of maximum 150 000 rows ?

Thanks,

Isabelle

Hi, I'm doing a lookup using Lookup Stage (but the same error is appenning with Join stage). Both Input file and Lookup fileset have the KEY field to retreive the VALUE field from Lookup fileset. The output file contains KEY and VALUE fields mapped from the Input and Lookup files. The problem I'm fa...

Thanks for the Welcome !

I found the sed command and it is in the path. I could not find the dbx command on the unix box. Can you tell me where to look at please ?

Isabelle

Hi, I'm trying to write to fixed length sequential flat file. I'm doing a concatenation (using operator : ) of many stage variables into one field of 485 chars. I'm handling all NULL fields with NullToEmpty function. I set the file format as follow : Record Delimiter = UNIX newline, Record length=48...