Datum 23.11.2007   Keywords DB2 for z/OS, Version 8 or DB2 9 is the last version that will support the internal security?

http://www-1.ibm.com/support/docview.wss?rs=865&context=SSEPEK&dc=DB510&dc=DB520&dc=D800&dc=D900&dc=DA900&dc=DA800&dc=DA440&dc=D600&dc=D700& dc=DB540&dc=DB400&dc=DA410&dc=DA450&dc=DA430&uid=swg21181070&loc=en_US&cs=UTF-8&lang=all

Problem
Is that true that Version 8 or DB2 9 is the last version that will support the internal security?

Solution
No. DB2 has both DB2 internal and external security. Any rumors to this effect are false.

GRANT and REVOKE are part of the SQL standard and help with DB2 family compatibility. Most customers use DB2 internal GRANT and REVOKE security.
Customers can also use external security via the Access Control Authorization Exit, such as for RACF access control. For guidance about which to use, see the Technote "Should I use the traditional DB2 security or RACF access control?"

When DB2® removes a significant function, IBM® generally identifies this change for customers as a deprecated function. Version 8 has several deprecated functions, including distributed private protocol, selective partition locking and DB2-managed stored procedures. DB2 9 has some items that are removed and other new items that are deprecated. See the Installation Guide sections on incompatible changes for the details. In DB2 9, see the chapter 8 section "Changes to DB2 that might impact your migration to Version 9.1 compatibility mode" and "Make adjustments for release incompatibilities."

While it is not always possible to provide an early warning for every new function, you can expect changes of this magnitude to be communicated clearly before they occur.

P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.

With kind regards
Michael Dewert, Software Group
DB2 Development
DB2 Information Management Software