Search found 231 matches

by DS_SUPPORT
Thu Apr 19, 2007 11:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Project Corrupted
Replies: 9
Views: 3166

Ray

I replied to Nick and I didnt see the reply from you( check the posted time) , Anyhow i created an case with my admin team, And as of now we are creating a new project as we have a backup of old project.

I just want to know , is there any way of getting back the corrupted project.
by DS_SUPPORT
Thu Apr 19, 2007 10:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Project Corrupted
Replies: 9
Views: 3166

we are having 5 projects in the server, only in 3 projects we are getting this error and in another 2 projects we are able to connect normally. So i think it may not be problem with permissions.
by DS_SUPPORT
Thu Apr 19, 2007 10:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Project Corrupted
Replies: 9
Views: 3166

Project Corrupted

we are not able to connect to our development project, When we tried to connect to the Project we are getting Error like "Failed to Connect to Host HOSTNAME, project : PROJECTNAME ( The directory you are connecting to either is not a UV account or doesnot exist (39125) ) By searching other post...
by DS_SUPPORT
Thu Apr 12, 2007 1:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed File 32BIT or 64BIT
Replies: 1
Views: 992

Search Should have revealed this
by DS_SUPPORT
Wed Mar 28, 2007 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed File Settings
Replies: 3
Views: 1096

Here Performance is in the sense, "fetching the results from Hashed File" when it is used as a lookup. So i have to consider the maximum number of rows when creating a hashed file. And my another doubt is, when the records will move to the overflow file as the dynamic hashed file will exte...
by DS_SUPPORT
Tue Mar 27, 2007 11:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed File Settings
Replies: 3
Views: 1096

Hashed File Settings

We are working in product development, so we are having some problem with the initial settings of the Hashed File.And we will always use the Dynamic Hashed File only. Let me take the example of employee table, as the employee count will differ from customer to customer. Let me assume one customer is...
by DS_SUPPORT
Thu Mar 15, 2007 10:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File name
Replies: 2
Views: 1606

A Search on this forum would have given you the results, Kim Duke has already posted lot of scripts to do the tasks like this. For you the code would be like select EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '45L', DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBOBJECTS.NAME AS LINK_NAME F...
by DS_SUPPORT
Wed Jan 17, 2007 9:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command stage
Replies: 33
Views: 8358

I am able to See command Stage in the Server Edition.

Image
by DS_SUPPORT
Tue Jan 16, 2007 5:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling empty hash files
Replies: 8
Views: 2496

You can always get the count of a Hashed file

Code: Select all

Select Count(*) from HASHEDFILENAME;
So here you can write a routine and check the rowcount of Hashed file, and based upon the result you can proceed your second job.
by DS_SUPPORT
Mon Jan 08, 2007 10:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: About DSUTILITY
Replies: 17
Views: 7377

Use the same code which is mentioned in another post

Code: Select all

C:\Progra~1\Ascential\DataStage7.5\DSExport.exe /U=Username /P=Password /H=HostName /JOB=YOUR JOBNAME ProjectName C:\hash\a.dsx
by DS_SUPPORT
Sun Dec 10, 2006 11:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: jobs not showing in Repository
Replies: 6
Views: 2134

I mean to tell choose the option2 while executing DS.TOOLS.
by DS_SUPPORT
Fri Dec 08, 2006 5:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: jobs not showing in Repository
Replies: 6
Views: 2134

try DS.REINDEX ALL in the command prompt. But be sure no client is connected to the server , when you are executing this command, or try DS.TOOLS 2.
by DS_SUPPORT
Fri Dec 01, 2006 1:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Differences Between 7.5.1 and 7.5.2
Replies: 2
Views: 1069

Differences Between 7.5.1 and 7.5.2

Hi

I want to know the differences between 7.5.1 and 7.5.2, I heard that some performance tuning has been done in 7.5.2. Can you direct me to any documents and can you list it?
by DS_SUPPORT
Wed Nov 29, 2006 10:24 pm
Forum: General
Topic: error adding to schedule when use daily option
Replies: 7
Views: 3977

I hope we have a case long back, regarding to this for Non-English versions of Windows, they have to do some settings at DSParams. Pasting the response from Ascential: Since you are running German version of Windows, the AT command (Windows Scheduler) doesn't understand English (default) names for t...
by DS_SUPPORT
Wed Nov 15, 2006 1:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to clear RT_LOG****
Replies: 6
Views: 12878

You can try "CLEAR.FILE RT_LOG****" from the administrator client