Search found 7 matches

by chanduch9
Mon Jul 27, 2009 3:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage conversion unix to windows
Replies: 9
Views: 5340

DS project Unix to Windows

Can someone suggest -> how to convert the sequential file Line termination from Unix Style to Windows Style. (Note:we are not allowed to use unauthorised packages or softwares) And while moving the project from Unix to Windows, are there any other issues other than 1.Unix scripts 2. '/' to '\' 3.Seq...
by chanduch9
Fri May 29, 2009 11:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL server connectivity
Replies: 1
Views: 1024

SQL server connectivity

Hi We need to change the Databse, planning to use SQL server DB instead of Oracele DB. For that i need to test the SQL connectivity in my environment. and i got a SQL server name ,DB name ,User_id and pwd. Can you tell me what are all i need to setup? before i create a sample job with ODBC stage (So...
by chanduch9
Wed May 27, 2009 4:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Locks or process are not listing in Director, How to get all
Replies: 7
Views: 2719

Hi All, We bounced our PROD server and restarted. Still Datastage director is not showing the list of Locks , processes in the 'Cleanup resources' window. ( I checked with Show All option also) Same issue is not there if i log in DEV server. (Our env, DS Server jobs 7.5.3.1 , Unix OS) Any kind of su...
by chanduch9
Wed May 27, 2009 11:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Locks or process are not listing in Director, How to get all
Replies: 7
Views: 2719

Yes, Same problem for all others also. None of us able to get the list.

Is this a problem with Indexing? should i try with DS.REINDEX ALL in Administrator?

Appreciate your quick response.
by chanduch9
Wed May 27, 2009 11:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Locks or process are not listing in Director, How to get all
Replies: 7
Views: 2719

chulett wrote:Silly question, perhaps, but did you click on the 'Show all' radio buttons? ...
I tried that option before i post it. I did all which we do usually, but i find this bit strange which i never face before.
by chanduch9
Wed May 27, 2009 10:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Locks or process are not listing in Director, How to get all
Replies: 7
Views: 2719

Locks or process are not listing in Director, How to get all

Hi When i open the Cleanup resources window in DS Director, it is not showing/listing any locks or process . Can you tell me how to get all those list. One o fmy sequence got locked and prompting a message 'accessing by other user' , i checked it, no one opend the sequence, how to unlock this sequen...
by chanduch9
Tue Apr 28, 2009 11:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to change Datastage Oracle stage to SQL server compatibl
Replies: 1
Views: 1681

How to change Datastage Oracle stage to SQL server compatibl

We need to change our Datastage environment Database Oracle9i to SQL server, now our biggest challenge is How to change the Datastage jobs - All Oracle stages to SQL server compatible? Till now we used ORAOCI9 stages. Please let me know your suggesions and steps to change Oracle - SQL server. any ki...