DSXchange

I ran my process and below is the glance report GlancePlus C.04.50.00 07:38:27 usplcpd1 ia64 Current Avg High ------------------------------------------------------------------------------------------------------------------------------------------------------ CPU Util S SU | 7% 7% 19% Disk Util F F...

I was using glance to monitor SWAP and DISK utilisations and i noticed that after few minutes of starting this job it is spiking to 100 % utilisation and then after few minutes the job abends. But not able to interpret what 100% means since the disk partiitons have enough space.

I have a look up and it is approximately 500 MB

Hi, I am facing a unique problem when i am using a 4 node configuration problem for Datastage 7.5.2 on HP-UX Itanium 64 bit box. We are running our jobs in production successfully till yesterday and all of a sudden we are facing below error: Could not map table file "/scratch/proj/DataSets/look...

Also my job is abending since there are no parameters passes by the stage as part of the call: BEGIN ICVMEXEC.BASE_OPTIONS_SPLIT(); END; I modified the stage and gave the input columns(hard corded) as below :Inputcol1,:Inputcol2 After the above change the error is The parameter (:IN_ORDER_MODEL_DESI...

chulett, Thanks for response.I scanned through the doc you mentioned and could not find some information about passing parameters. In STPSTAGE pdf 2.0 version stp stage has a seperate parameters tab but when i look into STP stage there is no seperate tab for parameters but it is sub propert under st...

I am using stored procedure for the first time and have exactly same kind of question you raised below.Appreciate if you can provide some input to below propeties from your successful usage of STP stage: STP---->Stage Tab: DataBase Name : Oracle DataSource Name : I have given the name as we would gi...

Hi,

Can some one help me out on converting julian dates to YYYYMMDD format?

I/P dates are of format YJJJ and sample values are 8222 and 8225

Y-is the last digit of the year
JJJ-Number of the day in the year


Any help is appreciated

Hi, Can some provide info on connecting to DB2 on mainframe. My Initial research reeals: 1) Need to have DB2 connect installed on Datastage Sever(7.5.2 on SunSolaris) 2)DB2 connect needs to be configured to register the catalogue to access DB2 tables. I want to know if i am missing any steps and wou...

Thanks for your response. So we need to have classic federation installed on mainframe and use the Classic Federation enterprise stage available with Information server to read and write data from IMS. If my above understanding is correct then we are talking about license for classic federation on m...

"Federation and/or Classic Federation are the preferred ways of doing this, for their integration with Information Server, although there are other connectivity solutions" What i want to understand is how this Federation andClassic Federation stage works from information server. To connect...

Hi, We want to connect to IMS from Information Server 8.0 and load/read data to IMS. Is there any way of doing it in 8.0 I came across a whitepaper where in it was mentioned that DataStage XE 's connectivity software available for read/write/delete from IMS. How is XE different from Information serv...

Hi,
I think currently between DataStage and DB2 the transmission is over TCP/IP protocol but the requirement is to secure the transmission .

Is there a way of securing the transmission.

Thanks,
Sree

Hi,

We want to convert our datastage server in 4.2 to parallel jobs in 7.5.1A mode.Is there any utility to do the conversion or is it that we have to recreate the jobs.

Thanks,
Sree

Hi,

I need to convert string format YDDDHHMM to timestamp format.

Y is single digit year

Ex: 80172034 should be converted as 01/17/2008 10:30:00

Any suggestions?