New document (PDF) "DB2 administrator's Unix Commands Survival Sheets" available: All UNIX commands DB2 administrators know but hardly remember. Covers some Solaris and most of the relevant AIX commands. Also covers some SAP R3 commands for SAP base administrators. Includes Some monitoring commands like top|topas, nmon, db2top. Also important code pages ... weiterlesen
Archiv: März, 2014
27
Mrz2014
Loading data of DB2 z/OS internal format into a DB2 Linux/Unix/Windows database became very easy. Either you use DB2 Connect to connect from any DB2 Linux/Unix/Windows to DB2 for z/OS. But this costs you a separate license fee. For a distinct class of DB2 LUW server (e.g. on AIX) IBM supplies ... weiterlesen
27. März 2014Gernot
18
Mrz2014
Does your application has to check cerrtain authorzation id's for certain access rights needed? Following SQL shows some ways how to proceed:
-- any userid between L0... and F9..., but letters are illegal
SELECT USERID,HEX(USERID)
FROM MY.TABLE_OF_AUTHIDS
WHERE USERID BETWEEN X'463F000000000000' AND X'4639393939393939'
OR USERID ... weiterlesen
18. März 2014Gernot
16
Mrz2014
Accessing DB2 for z/OS or DB2 for iSeries from client on DB2 for Linux/Unix/Windows? Do you  experience troubles accessing then remote server database? Missing a license file? How to install and custimize? DB2 JDBC driver is not licensed for connectivity by file db2jcc_license_cisuz.jar ERRORCODE=-4472 SQLSTATE=42968
http://www-01.ibm.com/support/docview.wss?uid=swg21413734
See chapter "Installing the IBM Data Server ... weiterlesen
16. März 2014Gernot
13
Mrz2014
Extended DB2 DRDA Security: Managing TCP/IP-based connection requests
Prepare requestors for access requests using extended security IPNAMES
LOCATION
USERNAMES Setting DB2 for z/OS DRDA AR to use encrypted passwords Using ICSF on z/OS Using PassTicket
How RACF Processes the Password or PassTicket
The role of TCPALVER system parameter
Troubles using PassTickets Unable to obtain a PassTicket - 00D31059
Invalid PassTicket passed - 00F30085 Protected ... weiterlesen
13. März 2014Gernot
13
Mrz2014
Automatic table maintenance work? When? How often? For which tables? These SQL queries will help to clarify questions of this kind.
--------------------------------------------------------------------------------
-- SQL-Statistics-Diag.sql - Statistics Collection Vorgänge
--------------------------------------------------------------------------------
--
-- Successfully completed autoReorg and autoRunst events:
SELECT DATE(TIMESTAMP), TIME(TIMESTAMP),
CASE
WHEN ... weiterlesen
13. März 2014Gernot