Search found 7201 matches

by admin
Thu Jun 26, 2003 10:51 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Datastage Error
Replies: 1
Views: 800

See response at: m ----- Original Message ----- From: "Babatunde.Ebohon" Date: Thu, 26 Jun 2003 10:19:28 -0500 To: Subject: Datastage Error > Hi all, > Does anyone knows what this error is ? and how do you resolve it. > Platform - Datastage PX 6.0 > its a server job. > > LoadFinSlsSummary..Transform...
by admin
Thu Jun 26, 2003 10:49 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: BUILD.INDEX error
Replies: 4
Views: 1453

To change the directory pointed at by the UVTEMP configuration parameter is a four step process. (1) Edit the uvconfig file in your DataStage Engine directory. (2) Stop the DataStage server. (3) Execute bin/uvregen while in that directory. (4) Re-start DataStage server. You will need to have execute...
by admin
Thu Jun 26, 2003 8:09 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: BUILD.INDEX error
Replies: 4
Views: 1453

Mario If you LOGTO UV and CONFIG ALL then you will see UVTEMP. That is where Universe creates most of its temporary files. It maybe full. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.com -----Original Message----- From: Dudley, Mario M [mailto:mario.m.dudley@boeing.co...
by admin
Thu Jun 26, 2003 8:00 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: BUILD.INDEX error
Replies: 4
Views: 1453

BUILD.INDEX error

Im attempting to build an index on a hashed file and get this: >CREATE.INDEX HashTDPI ITEM_NBR >.C/CREATE/BUILD 01 BUILD.INDEX HashTDPI ITEM_NBR >.X 01 BUILD.INDEX HashTDPI ITEM_NBR Locking HashTDPI file for exclusive use. Starting SSELECT for file HashTDPI index ITEM_NBR. Compiling "@Ak.0". FIELD (...
by admin
Thu Jun 26, 2003 3:43 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Oracle OCI plugin error
Replies: 0
Views: 752

Oracle OCI plugin error

Hi Folks, When trying to import metadata for OCI9i, I get the error "Unable to initialise plugin". Setup: Datastage V6, Oracle 9.2 (both on same server) Oracle works OK. The instructions were followed to install the plugin. dsenv was updated with : ORACLE_HOME=/opt/oracle/product/9.2.0 ; export ORAC...
by admin
Thu Jun 26, 2003 3:19 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Datastage Error
Replies: 0
Views: 521

Datastage Error

Hi all,
Does anyone knows what this error is ? and how do you resolve it.
Platform - Datastage PX 6.0
its a server job.

LoadFinSlsSummary..Transformer_9.DSLink15: ds_ipcput - timeout waiting for mutex
by admin
Thu Jun 26, 2003 3:14 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Antwort: Exporting read-only objects
Replies: 1
Views: 884

Udo That is the problem. In the command line version then you have no control over what it does or does not export. So read-only objects are not exported. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.com -----Original Message----- From: udo.neumann@eds.com [mailto:udo...
by admin
Thu Jun 26, 2003 9:35 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Antwort: Exporting read-only objects
Replies: 1
Views: 884

Antwort: Exporting read-only objects

Hi Chris, to eliminate the message please disable the option "Read-only objects" in the Option tab from the Export in DS Manager. This reflects also to the command line tool . Regards, Udo Chris Roberts 25.06.03 20:59 Bitte antworten an datastage-users An: datastage-users@oliver.com Kopie: Thema: Ex...
by admin
Wed Jun 25, 2003 8:14 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Exporting read-only objects
Replies: 4
Views: 3912

The count using the client is the same. Thanks Kenneth and Kim, Chris Roberts ----- Original Message ----- From: "Kenneth Bland" To: Sent: Wednesday, June 25, 2003 3:54 PM Subject: Re: Exporting read-only objects > Do you receive the same count when you use the client? > > DataStage has a lot of out...
by admin
Wed Jun 25, 2003 8:07 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Exporting read-only objects
Replies: 4
Views: 3912

Chris Kenneths answer is a much better answer. These objects are probably not needed in the backup. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.com -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Wednesday, June 25, 2003 1:55 PM T...
by admin
Wed Jun 25, 2003 8:05 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Exporting read-only objects
Replies: 4
Views: 3912

Chris I have played with this command and /O= is dealing with login screen. You may need to change the read only flag. In the Administrator on the command line option. SELECT * FROM DS_JOBOBJECTS WHERE READONLY NRO; This will list jobs that are set to read only. You may have routines set to read onl...
by admin
Wed Jun 25, 2003 7:54 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Exporting read-only objects
Replies: 4
Views: 3912

Do you receive the same count when you use the client? DataStage has a lot of out-of-the-box objects accessed thru DS Manager (functions, transforms, routines, stage types, etc) that are read-only because they are part of DataStage. Chances are those are the objects you see and you dont have to worr...
by admin
Wed Jun 25, 2003 6:59 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Exporting read-only objects
Replies: 4
Views: 3912

Exporting read-only objects

I am receiving the message "324 read-only objects were omitted." when I export a project using the command line program "dscmdexport.exe". The client is running on Win2000. The server is running on HP-UX 11. The command line I am using is "dscmdexport /H=xxxx.xxxxxx.com /U=dstage /P=xxxxxxxx Product...
by admin
Wed Jun 25, 2003 12:14 am
Forum: Archive of DataStage Users@Oliver.com
Topic: CFF stage and variable length input
Replies: 0
Views: 555

CFF stage and variable length input

Hi, I have ... and have been reading ... CFF Tech. Bulletin from August, 2002. Plus I have on-line doc of CFF stage in DStage v6.0.1. The tech bulletin is more current than the on-line doc, but there are still fine points I cannot find in the doc. My questions are in 2 parts: Part 1 -- CFF basics: I...
by admin
Tue Jun 24, 2003 4:22 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Process Design
Replies: 4
Views: 1257

Nuno, no matter what, your query requires in essence pivoting the results. My first suggestion was the easiest to do for a small number of like tables. Heres what you need to supply to better answer your question: (1) Is this a 1 time backfill or are you processing 360 million rows every single time...