DSXchange

Thanks Craig. So, if a the source COBOL file has 4 segments and each segment has 3000 bytes and we are interested with 1000 bytes in each of the segments, then for remaining 2000 bytes it should be FILLER PIC X(2000) in each segments. You mentioned contiguous secret stuff does that mean unused colum...

So you mean that if the file size 11340 bytes and our columns for interests consume 3000 bytes then remaining 81340 bytes should be made as FILLER in the Copybook?

Craig,

What our client has agreed to do that their data architect will create a copybook with selective columns ie 25% columns that SAS program is currently fetching.I see a risk here. Will it be feasible to read a COBOl file with a copy book containing partial fields?

We are insisting Craig but they are sending some documents with metadata. Our data architect is trying to create a a cobol copybook manually, my worry is whether that copybook will be reliable?

Hi All, Our requirement is to transform a process into DataStage where the old process reads COBOL binary files through SAS code and produces CSV files. DataStage will replace the SAS code and will read the binary files and converts them into CSV files. The main issue is vendor is not ready to share...

I am using a file connector stage in local mode. The job reads from a text file and writes to a file thru file connector. The job is aborting with te followin messae: File_Connector_3,0: An exception occurred: java.lang.RuntimeException java.io.IOException: Pipe closed (com.ibm.iis.cc.filesystem.Fil...

The link does not provide detail steps on back up procedure. Few questions raised by our clients:

1)Back up to be taken on the same server were engine and service tiers are installed?

2)Is isrecovery tool available in V11.5 for back up and recovery?

Hi,

My client has asked the back up steps for Service tier and Engine tier. We are using V11.5. Could you please help with the steps or link to the relevant documentation?

Hi Ray,

I will do.
Between, to copy the datasets from one directory to another, is it not sufficient to copy the descriptor files? Data files to be copied ? for that do we need to set the config files ?

I am not able to view the entire content as I am not a premium member.Could you please let me know the remaining context.

Hi All, Our UAT and Prod datastage env are hosted on the same server. Unix flle system is maintained using separate directories. Requirement is copying datasets and surrogate key stat files from UAT directiroy to Prod directoy (on same server). Does this copy pose any threat? is there any possibilit...

No luck today. The same issue persists. Suddenly some of the jobs are running extremely slow. Looks like environmental issue. Can we check if any phantom processes are stuck and that consumes resources? How can we check that?

Hi All, I have done something similar for our daily batch jobs. We call it Load_Information table. A static table is maintained with Job name, source table and target table name. A generic unix script is created to capture the audit information which is being invokes before/after job subroutine. The...

Hi Ray, Nothing has changed wrt Code. Till Friday, the execution was fine, slowness has been observed first on Saturday then on Sunday. Only diff I saw that number of rows/sec decreased significantly. What could be possible environmental issue that might cause this? Any weekend maintenance applicati...

Hi All, I have been observing for last 2 days that, our daily batch jobs have started taking longer than usual time. Normally as job that runs for 30 mins, now running for more than 2 hours. Our DB is Netezza, jobs that extracts from DB, are working normal but the other jobs where other datastage st...