Forgot your password?
Document Actions
General errors
Up one levelTablespace Offline. How can I change it to online ?
Tablespace Offline. How can I change it to online ?
What you do when you can't get to insert data in tables with identity column
db2 alter table <table_name> alter column <column_name> restart with <max(column_value)>
Insert and Delete Errors - SQL0668N Operation not allowed for reason code 7
How you do when you cannot insert or delete data in some tables
What are the Restrictions for HADR ?
What are the Restrictions for high availability disaster recovery (HADR)
SQL1224N - DB2 has terminated your connection
The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated your particular request due to an error or a force interrupt. SQLSTATE=55032
Error DB21017E - system error with the front-end process output queue
DB21017E The Command Line Processor encountered a system error with the front-end process output queue.
Altering the type of an identity column is not supported - SQL0270N REASON CODE=98
Drop the identity attribute, alter the type, then re-enable the identity attribute.
SQL1596N WITH EMPTY TABLE cannot be specified for tableX
what is another option to truncate a table that has children
sqloLinuxDoesFHSupportAIO when AIO is enabled
FUNCTION: DB2 UDB, oper system services, sqloLinuxDoesFHSupportAIO, probe:10 CALLED : OS, -, io_queue_init OSERR: EAGAIN (11) DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
SQLO_QUE_BAD_HANDLE "Bad Queue Handle"
MESSAGE : ZRC=0x870F003E=-2029060034=SQLO_QUE_BAD_HANDLE "Bad Queue Handle" DIA8555C An invalid message queue handle was encountered.
SQL0805N Package NULLID.SYS* was not found.
There might be instances where applications do not close their cursors after they are done with them.
Overring bufferpool size to start the database
If you add a new bufferpool or resize one you can have problems to start the database if the total memory used is bigger than the available memory of your system. You can also face this problem if you need to migrate a database to a new environment with less memory than the original.
Hacker Rangers - Gamification for CyberSecurity