Direct access to DB2 LUW database

[#1]

Hi

I am making a solid case to my bosses that direct access to database (bypassing the SAP) in not recomended. Are there any official documentation or note that spells that?

Much appreciated

[markus_doehr2 · Accepted solution]

> I am making a solid case to my bosses that direct access to database (bypassing the SAP) in not recomended. Are there any official documentation or note that spells that?

There's a nice blog:

/people/lars.breddemann/blog/2008/05/19/questions-to-sap-support-is-odbc-access-to-the-database-a-good-idea

The problem you have with direct database access is the fact, that there's only one user used to access the data. This means that this user can do everything on the database, he can even drop tables or the full instance.

Markus

[Former Member]

Thank you all I think i have more than enough to , if nothing else cover my back should things go wrong in the system

Regards

[paul_power]

Hi,

another point is that db2 uses operating system users as detailed in the administration guide.

Access via dbacockpit can be controlled and I assume your bosses will want to control who has access to the operating system users.

Regards,

Paul

[Former Member]

Hi,

As such there is no documentation with me which suggests that you whould nt directly access DB2 from OS level.

But yes, best recommended way is to do all administration from DBACOCKPIT which will give you freedom to administer your database from single screen.

Thanks

Sunny