Issue
I have problem in size of database because the free space of the database is less than specific percentage of total space.
Cause
Users used to update in the database and that lead to increase used space of this database
Continue Reading…
Issue
I have problem in size of database because the free space of the database is less than specific percentage of total space.
Users used to update in the database and that lead to increase used space of this database
Continue Reading…
When DB2 executes SQL statements, it returns the results of the operation into the SQLCODE and SQLSTATE fields in the SQLCA. SQLCODE provides key information about the success or failure of SQL statement execution.
Do you ever think to compress VSAM dataset?
Do you know how to enable SMS on your z/OS system?
Do you know how to start SMSVSAM Server?
How convert non-sms volume to sms managed volumes?
Do you know how to enable VSAM RLS on your SYSPLEX system?
Rule 1: Don’t Grant any DB2 Object for PUBLIC, you don’t know who will use this authority and get access to your DB2 subsystem.
Rule 2: Grant access to DB2 objects according to need to know concept, don’t give extra authority unless it is business need.
you can use the following script to display the number of fibre ports on your system that you have and also the status of each one, you can use it as a healthy check script : Continue Reading…
if you have more than one node and they are connected together through POWERHA (HACMP), ofcourse you need an easy way to make normal users change thier password and automaticlly updated on the other node.
How would I know if I am running a 32-bit kernel or 64-bit kernel?
To display if the kernel is 32-bit enabled or 64-bit enabled, type: Continue Reading…