Personal tools
You are here: Home DB2 Problem Resolution General errors
Navigation
Log in


Forgot your password?
 
Document Actions

General errors

Up one level

Tablespace Offline. How can I change it to online ?

Tablespace Offline. How can I change it to online ?

Read More…

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)>

Read More…

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

Read More…

What are the Restrictions for HADR ?

What are the Restrictions for high availability disaster recovery (HADR)

Read More…

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

Read More…

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.

Read More…

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.

Read More…

SQL1596N WITH EMPTY TABLE cannot be specified for tableX

what is another option to truncate a table that has children

Read More…

SQL0440N - Delete Errors

referential constraint corruption

Read More…

Can not rollback to save point

db2 UPDATE COMMAND OPTIONS USING c off

Read More…

Governor Errors - GOV0102W "SQLMONSS"

WARNING (15060) GOV0102W "SQLMONSS" warning: SQLCODE = "1626"

Read More…

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

Read More…

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.

Read More…

SQL0805N Package NULLID.SYS* was not found.

There might be instances where applications do not close their cursors after they are done with them.

Read More…

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.

Read More…

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls