Search found 84 matches
- Wed Jul 15, 2009 6:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not Enough space
- Replies: 11
- Views: 5911
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...
- Wed Jul 15, 2009 5:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not Enough space
- Replies: 11
- Views: 5911
- Wed Jul 15, 2009 5:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not Enough space
- Replies: 11
- Views: 5911
- Tue Jul 14, 2009 12:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not Enough space
- Replies: 11
- Views: 5911
Not Enough space
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...
- Tue Sep 02, 2008 10:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling Oracle Stored Procedure in Stored Procedure Stage
- Replies: 8
- Views: 11404
Re: Calling stored procedure
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...
- Tue Sep 02, 2008 10:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling Oracle Stored Procedure in Stored Procedure Stage
- Replies: 8
- Views: 11404
Calling stored procedure
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...
- Tue Sep 02, 2008 9:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling Oracle Stored Procedure in Stored Procedure Stage
- Replies: 8
- Views: 11404
Calling Stored Procedure
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...
- Fri Aug 29, 2008 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting Julian dates to YYYYMMDD
- Replies: 2
- Views: 2582
Converting Julian dates to YYYYMMDD
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
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
- Sat Apr 19, 2008 12:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 API using DB2 connect
- Replies: 1
- Views: 1345
DB2 API using DB2 connect
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...
- Wed Mar 12, 2008 8:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage XE
- Replies: 7
- Views: 6461
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...
- Wed Mar 12, 2008 5:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage XE
- Replies: 7
- Views: 6461
- Tue Mar 11, 2008 9:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage XE
- Replies: 7
- Views: 6461
DataStage XE
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...
- Fri Feb 29, 2008 1:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Securing Data Transmission between InformationServer and DB2
- Replies: 0
- Views: 915
Securing Data Transmission between InformationServer and DB2
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
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
- Tue Jan 29, 2008 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting jobs from 4.2 server jobs to 7.5.1A Parallel jobs
- Replies: 1
- Views: 1098
Converting jobs from 4.2 server jobs to 7.5.1A Parallel jobs
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
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
- Thu Jan 17, 2008 9:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting YDDDHHMM to timstamp
- Replies: 2
- Views: 1128
Converting YDDDHHMM to timstamp
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?
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?