1.只有承认无知,才能装下新的东西; 2.进步来自一点点滴滴的积累; 3.广博让你更优秀,而专业让你无法替代; 4.挫折和失败能够转换为一种财富。
访问量(1130537) 积分(1523) 等级(核心会员) 排名(6)
在数据库在线备份的时候会与Load和ALTER TABLE <表名> ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE发生冲突导致这两种操作被挂起,而在MIS系统中数据库往往比较大(TB级别很常见),备份时候经常花费几个小时,甚至1天以上的时间。当我们急需上述两种操作的时候,就需要kill掉备份,一般步骤如下: #1 找到备份连接 [db2inst1@limt ...
2024-05-08 08:46 515 0
1.收集日志 mkdir /tmp/`date "+%Y-%m-%d"` db2pd -alldbs -wlocks > /tmp/`date "+%Y-%m-%d"`/wlocks.out db2 list applications show detail | grep -i lock > /tmp/`date "+%Y-%m-%d"`/app1.out db2pd -alldbs -lock showlocks wait -applications -transactions -dynamic > /tmp/`date "+%Y-%m-%d"`/db2pd.out
2024-03-07 08:47 646 0
Question & Answer Question In DB2 v10.x why receiving SQL5035N when connecting to database even if the database level is the same as the instance level? Cause In DB2 v10.x if the file ownership of the local database directory is wrong when connecting to database, SQL5035N will be received. The follo
2024-01-18 16:47 739 0
Problem 执行db2stop force,实例无法停掉并报错。 SQL1072C The database manager resources are in an inconsistent state. DB2 may have been incorrectly terminated, or another application may be using system resources in a way which conflicts with DB2’s use of system resources. System resource cleanup may be required
2023-11-29 11:00 797 0
2022-08-16-15.22.17.651790-180 I1931E403 LEVEL: Warning PID : 11698 TID : 139894944950016 PROC : db2sysc 2 INSTANCE: db2dpf NODE : 002 HOSTNAME: hostHADR2 EDUID : 18 EDUNAME: db2fcms-0 2 FUNCTION: DB2 UDB, fast comm manager, sqkfT
2023-07-17 16:38 889 0
#!/bin/bash ############################################################################################################### # Script name: get_table_count.sh # Script description: Get "db2pd -d <dbname> -tab" information # Current Release Version: 1.0.0 # Script Owner: hbhe0316 # Latest
2023-04-27 10:39 1038 0
ALTER TABLE "DB2INST1"."T1" ADD PRIMARY KEY ("ID") DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0613N The primary key, unique key, or table partitioning key identified by "ID..." is too
2023-02-14 14:35 892 0
[db2inst1@test01 tmp]$ db2 "import from T1.ixf of ixf insert into db2inst1.T1" SQL3150N The H record in the PC/IXF file has product "DB2 02.00", date "20221125", and time "165702". SQL3153N The T record in the PC/IXF file has name "T1.ixf", qualifier "", and source " ". SQL3
2022-11-25 17:08 1455 0
SQL3022N An SQL error "-20285" occurred while processing the SELECT string in the Action String parameter. SQL20285N The statement or command was not processed either because the table named "DB2INST1.T1_202203" has detached dependent tables or because an asynchronous partition detach ope
2022-11-10 15:13 1216 0
1.执行命令报错 [xxx@xxx ~]$ db2 "call XXX.XXX(1,'ALL')" SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=4, TABLEID=22, COLNO=12" is not allowed. SQLSTATE=23502 2.查看是哪张表 [xxx@xxx ~]$ db2 "select tabschema,tabname,tableid from syscat.tables where TABLEID='22' AND tabschema='XXX'"
2022-09-28 08:43 1100 0
1.创建存储过程 [db2inst1@node01 tmp]$ cat 2.ddl create procedure sales_status (in quota integer) dynamic result sets 2 language sql begin declare SQLSTATE char(5); declare rs cursor with return for select * from t1; open rs; end @ 2.执行创建存储过程脚本 [db2inst1@node01 tmp]$ db2 -td@ -f 2.ddl D
2022-09-27 09:50 961 0
1.导出表结构 db2 connect to TESTDB db2look -d TESTDB -z DB2INST1 -e -x -t T1 -o DB2INST1.T1 -nofed 2.重命名table name,index name su - db2inst1 set -o vi db2 "set current schema DB2INST1" db2 "rename table T1 to T1_BAK" db2 "rename index IDX_T1_P1 to IDX_T1_P1_BAK" db2 "rename index IDX_T1_P2 to IDX_
2022-08-23 09:26 1406 0
收集数据 DBNAME=<database name>(注意: 使用数据库名代替<database name>) nohup iostat -D -l -T 1 180 > iostat.txt & nohup vmstat -tw 1 180 > vmstat.txt & db2pd -d $DBNAME -inst > db2pd.inst.1 db2 connect to $DBNAME db2pd -edu interval=30 > db2pd.edu.out db2 "call MONREPORT.
2022-08-19 15:04 1100 0
db2 "set current explain mode explain" db2 -tvf test.sql db2 "set current explain mode no" db2exfmt -d xxdb -g TIC -w -1 -n % -s % -# 0 -o ./explain.txt 9) TBSCAN: (Table Scan) Cumulative Total Cost: 305.174 Cumulative CPU Cost: 1.19168e+08 Cumulative
2022-08-19 14:59 983 0
客户机自动重新路由功能的主要目标是使 IBM® Data Server Client 应用程序能够恢复通信,以便应用程序可以继续工作,并将中断减至最低。顾名思义,支持连续操作的核心在于重新路由。但是只有存在等同于客户机连接的备用位置时,才能进行重新路由。将 IBM Data Server Client 用作 DB2 Connect™ 客户机时不需要重新路由。有关详细信息,请参阅有...
2022-07-27 20:49 1155 0