DSXchange

Hi Gurus. Today, I have tried to connect TERA DB using TERA CLI. But I could not connect to TERA DB with datastage using tera api stage and could not get metadata also using tera api. but I can connect by ODBC stage anyway. Actually, I want to use tera fast load stage and multi load stage. Error Mes...

Hi Gurus. Yesterdata, We has installed DataStage SAS relative Stoage (SAS Paralle Data Set Stage / SAS Stage). After the installation. I made Sample Job with SAS Parallel Data Set Stage). But The Problems is using file xxxx.psds and Actual File Name and location is written in xxxx.psds Automatically...

Hi Gurus. We tried to install datastage 7 on Solaris 2.8 My Machine has used UltraSparc 2 CPU. Anyway. When I tried to install datastage. gave below message. ==================== [DataStage Server 7.0 - Installation and Maintenance Utility] Unpacking summary text and license agreement Unmatched &quo...

Hi Gurus, Today, I inspected DSDeadLock.Log with DataStage 4.x, and Found some odd. Regurally Failure in LK_cleanup_pshm errors are written in the file. Is it affect the stabiliy of DS Job Process? I capture some log for sample ( please see below log capture.) SO I inspected some another site datast...

Do you use Remote Server?

Maybe yes, then use Remoter Server Property.

It 's in Connection folder and you can see Available porperties to add box.

Cheers

D.H Kim

Hi Gurus. We consider New Server For DataStage (DW Server). So I want to know what is more affect to job speed, TPMC Speed or The Number of CPU. Addition information of our circumstance, We use datastage 4.2, We did not use PX Module. and When the pick time, We run 30 more job parallelly. Oracel als...

Hi Gurus. We met DOS Command execution Problem with DataStage DSExcute Stage in Sequence Job. Our Job call Cognos cube building batch on Windows No batch file contain below contents ================================ rem ============================================================================ rem ...

Happy New Year To All, I Want to use dscmdexport.exe command for backup the project. But I get error message just. Attaching to 'test' ..... dscmdexport aborted: Failed to attache to the project. My Command is "dscmdexport /H150.100.129.23 /Udsadm /Pdsadm dwcapital01 c:\dwcapital01.dsx" Fo...

Maybe Your job look up OCI Stage or somelike that (External DBMS Tables) but If your job loo up the hashed file stage. NOTFOUND works Well.

How about use TCL HELP. You can logon UVSH mode. and type HELP ore HELP SQL etc logon to serve by telnet service (If You use Unix Server) Example is that cd `cat /.dshome` (If you use datastage 5.x lower ==> cd `cat /.uvhome`) . ./dsenv ./bin/uvsh HELP (For BASIC Command etc) HELP SQL (For SQL) Good...

bigpoppa wrote:Does your SMP and your MPP have the same C compiler?

- BP

We use SMP only.

Hi Guru. We try to get data through MQ Stage from Mainfram data. but Problem is at packed decimal data. For example 3 cols exist in Queue. A, B, C A col type is char, B col type is packed decimal and C col type is Char. Problem is in Col B. If B contain '2000' Hex values is 02000C. but When I write ...

Hi One We made DW with DataStage PX. and I already feed all data to DW initially. and We started Daily CDC process This monday with DataStage PX. and The Daily ETL Process is built in Sequence Job. but First day of CDC, DataStage Jobs made problem. So many PX job aborted. When I checked datastage l...

Hi One We made DW with DataStage PX. and I already feed all data to DW initially. and We started Daily CDC process This monday with DataStage PX. and The Daily ETL Process is built in Sequence Job. but First day of CDC, DataStage Jobs made problem. So many PX job aborted. When I checked datastage lo...