DSXchange

keshav0307 wrote:we have ORACLE RAC with 4 failover servers and successfully running with only one tns name in tnsnames.ora file, for all the four failover database instances

Hi,
Good to know that it works for you. Is it possible to have a copy of the tnsnames.ora file so that we can see where we are going wrong?

Really got nothing to do with DataStage, it is just another client like any other app or tool. That failover is all in the hands of your DBAs, how they have configured RAC and what's in your tnsnames file. The fact that it is 'RAC' under the covers is completely transparent to the outside world. ye...

We have a RAC with two failover dbs, PREQDB1 & PREQDB2. as separate entries on the tnsnames.ora, .odbc.ini and .uvodbc.config files. This works, but obviously requires that we connect to a specific DSN (either 1 or 2) whereas I think ideally we want a single DSN that can failover to the second s...

Thanks Priyadarshi.
I will update on this.

Regards,
Sjordery.

Mahadev, If I am not wrong you are talking about the start loop and end loop activity stage in the sequence job. But how to make this to run continiously and since the file names we cant hard code as date in the file name chnages every day so how to make this generic? Ray, No that is not the case,al...

Hi All, Set of files lands on a defined directory on data stage server. The names of the files are EM01MMDD.M EM11MMDD.M EM13MMDD.M The requirements are like; the data stage process should run continuously to check for any of the above three files and it should process once it finds any of the three...

When I tried to recompile DataStage job which was already compiled some time ago, I received the following error: "A configuration file (APT_CONFIG_FILE) must be set up to compile a Parallel transformer stage. (EX_TX_LTG_Sun_ESTS_INCR_ph1_job.ltgsumhistincr". Other developers getting the s...

Logging in to Adminsitrator as the owner of the file and running the command worked.

Thanks Craig.

Hi Craig,

I'll try logging in as the owner and see what happens. Will report back...

Thanks,
S

Hi All, In one of our projects, attempting to open the log on one of the job sub-directories results in the Director hanging until 'Not Responding' appears at the top of the window. I'm guessing that the logs are too big.. I did a little research on here and came up with a way of getting the biggest...

Hi All, I am just trying to read a sequential file having 1 column. When I count the no of lines in the file it shows 100 lines but 20 records having proper values rest are only blank lines i.e 80 times enter key has been pressed while writing. To avoid those records i specfiled the column as not nu...

OK, having had a good look around, it seems that it was imported into a different sub-folder. The table name is something like: SubName1.TableOne In the subcategories we also have SubName2. When imported, the table-definition was saved as: SubName2.TableOne Very strange, but at least we found it.

Hi All,

We have imported an ODBC table definition, and when viewed from the Designer repository window, it appears fine. However, when we use query builder in the ODBC Connector stage, the table definition does not appear in the repository at the side of that stage.

Any ideas?

Thanks,
S

Thanks again.

I reapplied the correct credentials to the user ids that were experiencing this and the issue appears to be resolved now.

Regards,
S

Ah! Thanks, I will have a look.