We help IT Professionals succeed at work.

IBM universe connection data.

We are trying to find a way to determine ODBC connection credentials that an old legacy application uses to establish its connect with a universe IBM database. It runs on a windows server. has anyone any pointers if familiar with such a stack on where exactly to begin to try and identify what account is used to connect the application to the underlying database. It has been handed over with very minimal documentation. I think the company who now takes on the modern equivalent of that DB platform is Rocket Software.

Failing that any specific files which can be copied away and 3rd party utilities that may be able to view the data without credentials. I wouldn't even know the actual extensions for the DB files.
Comment
Watch Question

lcohanDatabase Analyst

Commented:
All that info would be stored in the Windows registry on the computer/server where the ODBC data sources are defined and a registry search on the destination IBM server name and/or IP should reveal the specific details.
For instance in order to export an ODBC data source:
Open the Registry Editor on Windows: Start > Run > Regedit
For System DSN, navigate to HKEY_LOCAL_MACHINE > SOFTWARE (> Wow6432Node) > ODBC > ODBC.INI
For User DSN, navigate to HKEY_CURRENT_USER > SOFTWARE (> Wow6432Node) > ODBC > ODBC.INI
Click on the data source name
Click File > Export
File is saved with .reg extension
Dimitris MaleasData recovery engineer

Commented:
The only way is somehow to find the credentials from the database. Can you send the beginning and end of file?
The best is to upload the whole file but you said that you cannot even copy that.
In this case, only professionel can help you.
Database Administrator / Software Engineer
Commented:
Hi,

The only way to determine this would be to access the database and list all connections to it.
Then go through the list of users and compare to the list of users on your computer and/or AD.
See LIST.CONNECT here also the WHO command.

https://www.rocketsoftware.com/products/rocket-u2/rocket-unidata-v821-technical-documentation
https://docs.rocketsoftware.com/nxt/gateway.dll/RKBnew20/unidata/v8.2.1/unidata_adminguide_v821.pdf

Regards,
   Tomas Helgi
Tomas Helgi JohannssonDatabase Administrator / Software Engineer

Commented:
Glad to help.

Regards,
   Tomas Helgi