Search found 7201 matches

by admin
Mon Feb 17, 2003 3:45 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Aggregation of large data
Replies: 7
Views: 2498

Aggregation of large data

Hi, Running AIX and DS XE 6.0R3 We are currently testing our solution on a large amount of data, but already when we are trying to load 500.000 rows into our aggregator stage we get into trouble. We get an error regarding a mutex. (NBlkAggregationJob..Aggr_Nordea_Txn_FF.Nordea_Txn_Agr_Move: ds_ipcpu...
by admin
Sat Feb 15, 2003 5:09 am
Forum: Archive of DataStage Users@Oliver.com
Topic: UV pointers
Replies: 4
Views: 1398

----- Original Message ----- From: "J. Schatz JMS Data Management Inc" Date: Fri, 14 Feb 2003 20:32:26 -0800 To: datastage-users@oliver.com Subject: Re: UV pointers > I would appreciate a fuller description of this for Unix pathnames. When a hashed file is created in a directory rather than in an ac...
by admin
Sat Feb 15, 2003 4:32 am
Forum: Archive of DataStage Users@Oliver.com
Topic: UV pointers
Replies: 4
Views: 1398

I would appreciate a fuller description of this for Unix pathnames. Can I shell out to uv and do clear file if this syntax is used? The SYSDESC.PDF doesnt have (as usual) a good example. if my hash files are stored in /files/hash/ how do I set this? Must I refer to pointer only on command line? Than...
by admin
Fri Feb 14, 2003 10:15 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: UV pointers
Replies: 4
Views: 1398

If you already have pointers, you may need the OVERWRITING keyword on the end of this command. The SDK key management routines you should not need to move, they use a hashed file called SDKSequences within the project to store the next available key value. Take a look at the code for these Routines....
by admin
Fri Feb 14, 2003 2:25 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Event type Other=21 - ds_loadlibrary: error in dlopen
Replies: 4
Views: 1106

Tom, what version of AIX are you running ? the lowest supported by v6 is 4.3.3 I think and the C++ libraries need to be at least version 5.0.2.0 for the server and ODBC connectivity to work correctly. Hope this helps. Simon. >From: "Craig Hulett" >Reply-To: >To: >Subject: Re: Event type Other=21 - d...
by admin
Fri Feb 14, 2003 2:11 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Column Datatype Error between DataStage and ODBC Data Source
Replies: 0
Views: 497

Column Datatype Error between DataStage and ODBC Data Source

We are facing a problem in DataStage. Table definitions are imported from ERwin into MetaStage, then pushed to DataStage. Then DataStage accesses Oracle through ODBC to get the data. The columns that are of datatype NUMERIC in DataStage - generate errors when accessing the database because ODBC repo...
by admin
Fri Feb 14, 2003 1:55 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Event type Other=21 - ds_loadlibrary: error in dlopen
Replies: 4
Views: 1106

Hmm, dont think the 4 versus 1 cpus has anything to do with it, unless you are running PE. Would suspect either NLS or the C++ libraries as earlier mentioned. I dont have any experience with NLS, hopefully someone else can pipe up on that. -craig tom.peter.nielsen@nordea.com wrote: > we upgraded fro...
by admin
Fri Feb 14, 2003 1:47 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Event type Other=21 - ds_loadlibrary: error in dlopen
Replies: 4
Views: 1106

we upgraded from Version 5.2 (with NLS on the QA environment) the Development server was using version 5.2 without NLS The QA has 4 cpus, the development machine has just one cpu - Tom -------------------------------------------------------- Tom P. Nielsen Project Masterdata Reg.nr. 4853 / HH55.1.3 ...
by admin
Fri Feb 14, 2003 1:42 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Event type Other=21 - ds_loadlibrary: error in dlopen
Replies: 4
Views: 1106

What version did you upgrade from? Im wondering if your C++ runtime libraries are not up-to-date on the QA server, and if you made a big enough leap in versions, this may just be showing up. It was an issue for me in a Compaq Tru64 environment, not sure about AIX... -craig tom.peter.nielsen@nordea.c...
by admin
Fri Feb 14, 2003 1:03 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Event type Other=21 - ds_loadlibrary: error in dlopen
Replies: 4
Views: 1106

Event type Other=21 - ds_loadlibrary: error in dlopen

Hi, We just upgraded our AIX serveres to DS version 6.0R3 and now we have an unknown error in our job that loads IDOC (ACC_GL_POSTING01) Its not present on our development machine, only on the QA environment - so its probably something on the server. Im getting events of the type Other=21, and the o...
by admin
Fri Feb 14, 2003 10:37 am
Forum: Archive of DataStage Users@Oliver.com
Topic: UV pointers
Replies: 4
Views: 1398

Hi Hendrik, go into your project in Universe and write: SETFILE Wolfgang > -----Original Message----- > From: Hendrik Kuhn (ZA) [mailto:Hendrik.Kuhn@za.didata.com] > Sent: Friday, February 14, 2003 11:18 AM > To: datastage-users@oliver.com > Subject: UV pointers > Importance: High > > > Hi All > > I...
by admin
Fri Feb 14, 2003 10:18 am
Forum: Archive of DataStage Users@Oliver.com
Topic: UV pointers
Replies: 4
Views: 1398

UV pointers

Hi All I have my HASH files in a different directory as where the project files is. I will want to change the pointer so that I can get to the HASH files using a uv stage. Can anybody explain to me how to go about this and how to move the SDKSequences file aswell because we use keys generated by dat...
by admin
Thu Feb 13, 2003 10:44 am
Forum: Archive of DataStage Users@Oliver.com
Topic: How to process a XML input file with missing tags ?
Replies: 1
Views: 4303

Hello Tino I had a similar problem with XML source data being incomplete i.e. optional fields were being delivered. One way round this is to append a "dummy" tag onto the bottom of your extraction in your first transformer with a path to the parent tag of the DTD. e.g. if youre expecting a field cal...
by admin
Thu Feb 13, 2003 3:41 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Need to append TimeStamp to File name
Replies: 5
Views: 9014

Another opportunity is to use one of the macros that also acts similar to a job parameter. For example if you wanted to append/prefix a datastamp of when the job ran (i.e. wrote the file) you could use in the target stage path: /whateverdirectory/mytargetfilename_#DSJobStartDate#.txt This will resol...