DSXchange

Hi,
I am trying to add new project using datastage administrator (add project option).
I get the following error message - DSR.ADMIN: Error updating secondary indices.

Any thoughts or ideas.

Kefos

Hi, I am trying to load into teradata database 12.0 on HP Unix 11.3 The source is sequential file or an Oracle table. I am getting the following error message when it try to load data into the table. Teradata_API_21: -1 Message Not Found The job aborts after the error message Datastage version 8.1 o...

Hi,

I am login as the administrator and have all the privleges as suite administrator.

this is the admin user we set up while we installed the IBM Information Server under which Datastage 8.1 runs.

ketfos

Hi, I agree datastage Projects are created using the administration client. What is the project which is referred in IBM Information Server tool. This is the option you see when you open Information Server, under the File Menu -- New Project and Open Project. My question is what is Project been refe...

Hi, Is this the right forum for posting question on IBM Information Server. Datastage 8.1 runs under IBM Information Server. I am logged in as adminstrator in IBM Information Server. 1. The New Project option under the File menu is disabled. 2. When I click under Open Project under File Menu, I do n...

Hi,

I did review the various posts on this topic.
Tried various options suggested.

But none of them could make it work.
I still get the same error message.

Thanks
ketfos

I am using Datastage 8.1 Server Edition, HP UX 11.3, client Windows XP. I am able to connect to Web Console. Using the same user id and password, I am not able to connect to IBM server console, Datastage Designer, Director or Administration. It comes with error message - failed to authenticate user ...

yes, I should have been some specific.

The problem was in the new index created on the table, which we found when we did Explain Query Plan.

The index was removed and update process took normal time.

thanks

Ketfos

Hi, I have a job in production which has been running fine all the days. This morning I found that it was running at 10 rows per sec. I stopped the job and started again. I noticed that it started with 300 rows per sec and slowly started to drop and after 5 minutes, it is showing me 10 rows per seco...

hi,
Does teradata 12.0 supported in Datastage 7.5 Server Edition?

Thanks

Hi,

You could use Before Job SubRoutine properties in Job Control window.
Select Before Job Routine ExecSh
Input value du -sk <filename>

This will give you file size.

Depending upon it you can take further action.


Ketfos

You should check for memory and swap size param.

Hi,
Can share the datastage job log?

Ketfos

hi, is your custom sql able to delete rows outside datastage. i.e using sqlplus or TOAD. Ketfos I have job requirement in which i have to delete some rows in the target before inserting into the target table depending on combination of key and nonkey coloumns. in target i have 22 coloumns in which 3...

Hi,

We installed DataStage Server 7.5.0.2 on Unix.

I am trying to connect to Oracle 9.2.0.8 on unix while creating a new jobl.

I am geting an error message "Unable to Intiazlize plugin"

I am able to connect to Oracle database using sqlplus session on Unix.

Ketfos