Category Archives: Information Management

This Category for all Databases

Volume Group Characteristics

Posted on February 13, 2015 by UNIX Admin

You can find below the meaning of each parameter on Volume Group Characteristics (the output from lsvg vg command):   Volume Group: Name of Volume Group. VG State: active/partial. Partial indicates that some of the Physical Volumes in the Volume … Continue reading →

Error: 1601, Severity: 17-Sybase

Posted on May 16, 2013 by DB2 Administrator

Error Explanation There are not enough ‘user connections’ available to start a new process. Retry when there are fewer active users Recommended Solution 1. Determine the current number of user connections configured: by using the following command

How to increase size of Sybase database on UNIX platforms ?

Posted on March 26, 2013 by Sybase Admin

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

Common Error Codes in DB2 for Z/OS

Posted on March 24, 2013 by DB2 Administrator

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.

VSAM for z/OS

Posted on March 23, 2013 by DB2 Admin

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 … Continue reading →

DB2 for z/OS Common Rules

Posted on March 23, 2013 by DB2 Admin

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 … Continue reading →