DSXchange

We bounced the Information Server stack and all is well. I did not try the other alternatives but will keep this post handy for occasion when a bounce is not as feasible.

Thanks! :D

When logged into DataStage and I try to save a job to another folder and change the name I get the below error: The Folder '\Jobs\FMS_E\OWS\Base\Load_Tables\Server' is locked by user 'username' (SessionID 'E8BA9E6E-905E-48D2-AE0D-628CF2C01B90') How do I address this? Should a user be able to lock a ...

Okay. Could the fact that these files are 64 BIT instead of 32 BIT have something to do with it.? I know that the UVFIXFILE is only operational on 32 BIT files. Could this be the case with fixtool.exe?

Thanks Ray! I ran the fixtool and received following: F:\Ascential\DataStage\Projects\FSCM9_EPM9_SPRDDW>F:\Ascential\DataStage\Engine\bin\fixtool -level 3 -file HASH_FSU_F_LEDCONSOL_EX ISTS Filename: HASH_FSU_F_LEDCONSOL_EXISTS Start Diagnostics. 0 Errors found in physical structure. 0 Errors found ...

Recently I converted a hashed file from 32 bit to 64 bit. This changed was prompted by an increase in data volume. Prior to converting the file to 64 bit I confirmed that it only contained the required keys and data (2.7 GB). This file is used in a major ETL process. Since the conversion to 64 bit t...

We are in the process of planning an install of DataStage 7.5.2 on Linux. The Hardware/Software requirements from the IBM site is below: Software ------------- Redhat enterprise ASE 2.1 gcc 3.23 TCP/IP protocol configured between client accesses Hardware ------------- 512 MB RAM (Recommend 1 GB); 60...

Thanks Ray..The separate indexes resulted in improved performance. I now have 3 indexes.

I've created a universe table to store information for lookup purposes. I chose to use the universe table instead of the hashed file because my criteria for the lookup is a date range. The universe table has 5 keys, two of which are date fields. Column Type Key ----------------- ----------- --------...

ArndW wrote:Byron - take away the trailing ";" semicolon.

That works! Amazing how small characters can make a big difference. Thanks.

It would have been nice to encase your LIST.INDEX between Code tags - in fact, why not edit your previous post to make it so? BUILD.INDEX is required if there are data in a hashed file on which an index is created. BUILD.INDEX is not required if the hashed file is empty when the index is created. T...

Below is the output for one of my UV tables. If data existed in the table before creating the index, is an index rebuild required? If so, what is the syntax? >LIST.INDEX HASH_D_JRNL_SOURCE_LKP2 ALL Alternate Key Index Summary for file HASH_D_JRNL_SOURCE_LKP2 File........... HASH_D_JRNL_SOURCE_LKP2 I...

DSguru2B wrote:How are you loading your fact table now. Are you collecting all your data into a flat file in one job after all the lookups and transformations and then in a second job loading into your table or everything in one job without an intermediate sequential file stage?

Yes all in 1 job.

Thanks the replys. Monitoring the process with prstat, mpstat, and sar simultaneously. No major bottlenecks in memory, or CPU utilization. In fact the cpu utilization peaked at 81% on all 4 cpus during processing. For SCD II, some of the lookups require the date range criteria. This is not accomodat...

I have a fact table loading process that is not performing to my expectation. It's taking my ETL process 33 minutes to load 170,000 Rows (3 MB) of data (approx. 85 Rows/Sec). The data is extracted and loaded into tables in the same Oracle Database (using DRS stage). This process populates data into ...

It is XP SP2. This is very odd because I can open and interact with all other DataBase stage types (Oracle, Redbrick, Informix, DB2...). However when I open the DRS, the designer freezes.