DSXchange

Hi Group, Can any one tell me why this error is coming, name_alias_11..Dest_name_alias.IP_02: DSD.BCIClose call to SQLTransact failed. SQLSTATE=S1000, DBMS.CODE=-95 [DataStage][SQL Client][ODBC][DataDirect][ODBC Informix Wire Protocol driver][Informix]Unexpected Network Error. SQLSTATE=S1000, DBMS.C...

Hi Group,

How can i estimate the disk space of a project. Say if i have 45 jobs and 100 hash files. how can i fix the disk space. And where to refer that. From the development side, the project was finished. need to be given to production.

Thnx in advance.

Hi,

Load the tables in the table defination category, and in the Manager,therez a option called Usage Analysis.

Select the table which u want to check from the table definition, then click the Usage Analysis option. U can see all the jobs, which uses this table.

Thnx

Rajiiv.

Hi Group,

Can any one tell me wht are all the types and its functionality of creating hash files in a command window,

eg.,

CREATE.FILE TEST 19

thnx in advance.

Hi Lakshya, If u want to have it in a sequenctail means.. my suggestion is to give a reject file with the job itself, say if ur target stage is a odbc stage, with name Target23. In the transformer previous to the target23, have another link for the reject file. Iin the reject file link constraint, c...

Hi Group, if am running a job with 2 lacs records. if suddenly my job fails after 1 lac record, is there any way to recover those records which already passed. That if i run for the second time the same job, it should start from the last load record instead of staring from the first record or begini...

In child sequence, in the job properties --> peformance tab, click the 'Automatically handle activities that fail' check box, i hope this will solve ur problem. also in the master sequence click the 'Add checkpoints so sequence is restartable on failure' check box, it will make ur master sequence to...

Your network connection is broken. Check whether you can ping the Server machine. Alternatively did you have some 'OLE' problem before this? Hi Sainath, This error is thrown only if i use the DRS stage. I just added a DRS stage and tried to have View Data, then this problem araises. prevouisly the ...

Error is : Error calling subroutine : DSD.Browse(Action=2);check datastage is set up correctly in project grephase (The connection is broken (81002)) Error calling subroutine : DSD.EXECJOB(Action=5);check datastage is set up correctly in project grephase (The connection is broken (81002)) Error call...

thnx chulett its working fine.

Hi chullet,

its not actually a general question. see if i give dsn, username and password. instead of seeing the View data from a database stage.. is there any other option, just i want to verify the give dsn and the username password is working properly for the database stages...


thnx in advance

Hi all,

how do we verify that we are able to connect to all the databases that are setup in particular job, means in the source and the target odbc stages.

thnx in advance.

The message tells you exactly what's wrong. You are not authorised to use the at command on the UNIX server. Contact your UNIX administrator; you may need to be added to cron.allow, or you may need to be granted write access to the atjobs and/or cronjobs directory (or added to a group that has such...

Hi group, I tried a schedule a job, through director--> job--> Add schedule... After giving the timings i clicked the schedule button, it throws an error like the below, " Error adding to Schedule: u r not authorized to at. Sorry. command was at 20:00 today. (Data was: Ascential/DataStage/Proje...

Hi, 1. We are facing a problem in running released jobs through server edition. Its giving mutex error problem for the IPC stage. The same job is running fine with non_released version i.e., the original job. Its throwing error only for the released version. we are sure that we released the exact jo...