DSXchange

Hi All,

We are upgrading from WAS 6.0.27 to 7 version , My worry is, will there be any impact for Datastage8.1 application because of this WAS upgrade. Could you guys please help me.

Thanks
Selysa

Hi chulett, Thanks a lot for the quick response ,$ORACLE_HOME and the variables related to operator will be specified Operator specific variable, but these variables are user defined variables. How and where these user defined variable pointing to the db2 database? Note : I verified in dsenv files a...

Hi , In our present aix server we have datstage 8.0.1 and db2 database which is our src and tgt system. We migrated the entire project in to new aix server,when we check the connectivity between database and datstage (validated and tried to view the data) it had given an error "db2 database ali...

Hi All, After searching a lot in the dsx forum, am posting this issue. Am trying to load a data from src table to staging table which has same structure as src. In that table, I have timestamp field x which is nullable in src and staging. When I do a one to one load it was failed and it says SIGSEGV...

[quote="ray.wurlod"]The best answer is "it depends". If the database server has spare capacity and/or if the join columns are indexed then chances are that the join will be resolved faster in the database. But the job ...[/quote]

Thanks Ray

[quote="ArndW"]Are all the tables in the same database? That is probably the most important factor for this question. ...[/quote]

Thanks for the quick response, all are in same database

Hi All, I have a requirement to join 3 tables which has is having more than 10 million of data on each and send the output to the target table(In between I have few transformation). My question here, 1) Can I go for Database join while extracting from the database? 2) Can I use Datastage join stage ...

[quote="abhijain"]Hi, there are already replies available on the forum for your query. Do search, before posting any of your query. :? Hope this helps you - [url]http://www.dsxchange.com/viewtopic.php?t=131351&highlight=schema+file[/url][/quote] Hi Abhijain, Thanks for your reply! I se...

Hi all, I have a scenario to extract multiple files with variable columns and load in to a database. While loading in to database, at run time it has to create a table with source file structure. For ex, 2 different file with different columns should create 2 tables with same src structure and load ...

[quote="miwinter"]OP - You are on v[u]7[/u]x, right? I've not seen an error like this before that's all but I know there was a newly produced error code reference of some ilk for v8. Furthermore, when you say [quote]the job is aborting saying Parallel job reports failure (code 139)[/quote]...

[quote="ArndW"]Is there any more to the error message, the Segmentation fault and abort message don't narrow down the issue at all. Also, does the new SELECT function correctly from your preferred tool? ...[/quote] Thanks for response Arndw, Same query is working fine in Toad, but I tried ...

Hi All, We are facing performence problem in a job which will execute merge query in Oracle database. I tried to modify the query to split the volume & run it paralley.Below is the original query, MERGE INTO #$DM_SCHEMA_PREFIX#PART_FACT a USING #$DM_TMP_SCHEMA_PREFIX#TMP_PART_FACT b ON ( a.deale...

Hi All, We have a sequence which runs in production server, When the sequence was running it creates 8 multiple instances,The issue here is, it runs some instances succesfully but for some instance am getting the below error. [color=red]JobControl (@Coordinator): Controller problem: Error calling DS...

Hi guys,

AM facing error in production,

Error setting up internal communications (fifo RT_SCTEMP/Ld_Veh_Warranty_Coverage_PXJob.fifo); file is locked.
LOCKED STATUS () -1

Please advise me, How to rectify the error?

Thanks
Selvam

Friends, Job was aborted and it throws the following error, subArgs={asc}}},1: Fatal Error: mmap failed: Not enough space, I understood some space issue is there, but here what is meant by mmap (is this memory map). Previous message of the above error was, buffer(10): When checking operator: Operato...