The connection is broken (81002)

swarnaaneel · Post by **swarnaaneel** » Mon Jan 30, 2006 5:34 am

Hi friends ,

When i am trying to access the table defnitions it is giving error as bellow ,pls help me where i have to reset in project

Error calling subroutine: *DataStage*DSR_SELECT (Action=4); check DataStage is set up correctly in project EMS
(The connection is broken (81002))

ArndW · Post by **ArndW** » Mon Jan 30, 2006 5:42 am

Hello Aneel,

the SEARCH facility in this forum is quite powerful, I search using the subject line of "The connection is broken (81002)" and got 48 matches!

There are several common causes of this error. If you only get it when accessing the table definitions and not other parts of the repository it might be a corrupted hashed repository file index.

You would need to use the ADMINistrator and issue the DS.TOOLS option 2, or execute the command (from the Administrator) "DS.REINDEX ALL" {please note that all DataStage users must be logged out, or else the indices might become unusable and nobody will find their jobs until the command is executed again}

raj_konig · Post by **raj_konig** » Mon Jan 30, 2006 8:50 am

Hello Arnd,

may I know how u know all these commands? Is there any PDF or some other doc where can get all these commands information.

Its a question raised out of enthusiasm

rajesh

ArndW · Post by **ArndW** » Mon Jan 30, 2006 9:01 am

The DS.TOOLS command is documented; if you look at the entry in the VOC file you will see that it is a MENU, which in turn can be looked at and which shows the actual TCL commands issued. The real reason is that some of us have been working with UniVerse and it's compatible products for more years than we'd like to admit, so it is easy for us to identify those commands that aren't part of the base product.

Please note that these commands are, for the most part, intentionally left undocumented by IBM/Ascential because they are not normally required for users of DataStage and that the potential for incorrectly using them can be a corrupted project or even a broken DataStage installation.

The best way to learn much of this is by downloading the UniVerse documentation (for free) at IBM's web site. But DataStage is being developed to go away from this kernal engine so any knowledge you get regarding the internals will, at some point in the near future, become obsolete.

raj_konig · Post by **raj_konig** » Mon Jan 30, 2006 10:05 am

Thank you for the information

rajesh

swarnaaneel · Post by **swarnaaneel** » Tue Jan 31, 2006 5:15 am

thank you Arnd ,as u suggested i exceuted the command,now it is working fine