what is the equivalent of OPS$SIDADM in DB2 UDB?

[Former Member]

Gurus:

In Oracle we have OPS$SIDADM and OPS$ORASID. What is the equivalent of them in DB2 UDB?

Also what is the equivalent of sapr3 user in UDB?

If an object is NOT in the schema of syscat, what schemas it may be in?

Thanks !!

[hans-juergen_zeltwanger · Accepted solution]

Hello Jennifer,

as far as I know, the OPS$ mechanism allows to connect to an Oracle database with the user being authenticated by the operating system. (Please correct me if I am wrong)

On DB2, users are always authenticated by the operating system. Or in other words, there are no pure DB users, they always exist on the OS.

"sapr3" also exists on SAP / DB2 systems. With newer installations, this was replaced by sap<sapsid> (to support "Multiple Components in One Database" setups). So depending on when and how your system was installed, either one of sapr3 or sap<sapsid> is used.

Schema names besides syscat, are either sapr3 or sap<sapsid>.

Above is true for the ABAP stack.

On a JAVA stack, the connect user is called sap<sapsid>db.

Regards, Hans-Juergen

[Former Member]

db2 connect user SAPR3

-Damien

[Former Member]

SAP with DB2 uses a password file. See:

http://help.sap.com/saphelp_nw70/helpdata/en/aa/1dc8f9f0fa11d3a6510000e835363f/content.htm