It's possible some of the tables showing STATS_TIME "-" in syscat.tables catalog table even when the auto-runstats in the database is tunred ON. The main reason might be, if a table is never accessed, then auto-runstats will not action on that table, even if the table has never had runstats done. This is by-design. This could be applicable for system tables as well as user tables. Regarding system catalog tables there might be differences of observations from... [More]
Commonly if db2stop/db2start fail with I/O errors it might point toward a corruptions of some kind at filesystem level. Or, either instance binaries are corrupted or, database catalogs /directories have issues. But, before getting worried do a quick check with db2diag.log messages with db2stop/db2start db2diag -A db2stop And, then check the db2diag.log entry. It might fail with I/O error even if an important file system like /home is ... [More]
When the database recovery happens DB2 retrieves the transaction log files and use those for rollforward. If the logs are compressed ones then it first DB2 uncompress those to same name except .EXP extension before using that. In-place uncompress also possible if logs are uncompressed manually using internal log uncompress tool. This is one reason, the DB2 cannot use a compressed log in a read-only filesystem as it cannot write the .EXP file there.
Yes, update record in a partitioned table will move the record to the corresponding partition. Below is a test to show exactly what happens when a row is updated in a partition table for the given scenario: 1. Create a partition table ranged by column "ID", partition 0: ID (1-10), partition 1: ID (11-20) 2. Insert 3 rows: ID = 1, ID = 2 and ID =11 3. Use command db2 "select datapartitionnum(<column name>) from <table name>" to check which partition each record... [More]
When customer using native encryption, in DB2V105FP5 and later fix packs, they may find that the following function and routine are missing: ADMIN_GET_ENCRYPTION_INFO and ADMIN_ROTATE_MASTER_KEY . db2 "select substr(funcschema,1,12)as funcs, substr(funcname,1,30) as name from syscat.functions where funcname='ADMIN_GET_ENCRYPTION_INFO' order by 1,2" FUNCS NAME ------------ ------------------------------ 0 record(s) selected. db2 "select... [More]
In a Windows DB2 setup there are two kinds of Command Winodw - DB2 Command Window - Administrator - DB2 Command Window Sometimes running a simple command from ordinary Command Window can return various unexpected errors. Examples, C:\Program Files\IBM\SQLLIB\BIN>db2level SQL1022C There is not enough memory available to process the command. C:\Program Files\IBM\SQLLIB\BIN>db2 connect to sample DB21018E A system error occurred. The command line processor could not... [More]
In the case customer wants to move the data from the current storage path to another storage path, or, simply wants to add/remove storage path, we can do it by rebalance. Below is an example: Create a database with a storage path: db2 "CREATE DATABASE SAMPLE ON /home/chungao/storpath1 DBPATH ON /home/chungao/datapath" After the database is created, we can see the database files are created under the DBPATH (/home/chungao/datapath) and the container files are under storpath1 (/home/chungao/storpath1). Add a new storage path and drop... [More]
During offline or online backup, customer encounters bad page error and backup fails, however when using db2dart to check the database, the result is clean. In db2diag log similar entries can be found: 2015-07-01-11.51.04.622000+600 E41122675F504 LEVEL: Info … FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1802 MESSAGE : Starting an offline db backup. 2015-07-01-188.8.131.526000+600 I41123181F803 LEVEL: Warning …... [More]
Abstract: On primary database, if some tables were altered with not logged initially, after takeover, how to figure out which tables are currently under inaccessible state? DB2 *does not * record the status of tables altered with not logged initially in catalog tables and query for status in syscat.tables is always NORMAL, thus the status of these tables cannot be queried by SQL. Solution: One solution is using " load query table " command to check the status of the table. Below is a shell script to check all the inaccessible table... [More]
If you see an old log file S0XXXXXX.LOG which is out of sequence, in failarchpath, and have no db2diag.log to show if the file was archived properly or if it was retrieved again etc., there is no need to panic, we can fix it. You will see that db2 continuously is logging messages as below or similar in the db2diag.log : ------------------------------------------------------------------------------------------------------------------------------------ 2016-01-04-184.108.40.2061346+000 E2137A532 LEVEL: Warning PID : 16384028 TID : 4371 PROC :... [More]
Did you know that our Information Management Support experts also post technical support content on Twitter? We just reached 5,000 tweets and counting! Find current support information about our Information Management products by following IBM_IM_Support . And, if you are interested in DB2, you can follow db2_support for specific DB2 support tips and info. P.S. We're also on Facebook: Information Management Support and DB2 Support LUW .
Recently we receive several customer issue of downloading InforSphere Data Explorer 8.2-3 from Fix Central. Sorry for any inconvenience. To resolve this kind of issue please contact them by calling 1-800-IBM-SERV or emailing them at UStsmail@us.ibm.com. InfoSphere Data Explorer Engine Support IBM Company IBM Support Portal at www.ibm.com/support .