DB21034E - Alter Table problem

Red Hat Linux DB2 8.2 Enterprise Server Edition db2 'ALTER TABLE APPL_LOG ALTER COLUMN DETAIL SET DATA TYPE VARCHAR(30000)' this returned a error message : DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0670N The row length of the table exceeded a limit of "4005" bytes. (Table space "USERSPACE1".) SQLSTATE=54010 The normal solution would be to expand the Tablespace. Given the allocations already on this server this would be problematic. Given that the data length for this column was potentially large , a CLOB... Read more →

ADM12017E - db2 license - add processor

There is a probe , which returns the follwoing message MESSAGE : ADM12017E The number of processors on this machine exceeds the defined entitlement of "1" for the product "DB2 Enterprise Server Edition". The number of processors on this machine is "2". You should purchase additional processor based entitlements from your IBM representative or authorized dealer and update your license using the License Center or the db2licm command line utility. For more information on updating processor based licenses, refer to the Quick Beginnings manual for your platform. For more information on the db2licm utility, refer to the DB2 db2licm -n... Read more →

db2diag.log file filling

There are a number of PIDs - which have been causing high amounts of CPU usage since last Sunday which are repeatedly throwing the following error LEVEL: Error (OS) PID : 7564 TID : 3086759616 PROC : db2pfchr 0 INSTANCE: db2myInstance NODE : 000 FUNCTION: DB2 UDB, oper system services, sqloCSemP, probe:1 CALLED : OS, -, unspecified_system_function SERR: EIDRM (43) 2008-12-15-10.59.40.404497+000 E2190G306 Looking at these processes , they are taking about 70% of the CPU continiously. These are errors , and as I have the Notify Level set at Level 2 they are reported into the db2diag.log file for this... Read more →