摘要:
每天一条DB2命令-037#收集快照脚本,db2_snap.shdb2 "update monitor switches using bufferpool on lock on sort on statement on table on timestamp on uow on"db2 -v rese 阅读全文
摘要:
vmware环境下往虚拟机里放文件会发现文件大小不对,可以在进入下面的目录,/home/jason/.cache/vmware/drag_and_drop然后例如9gasOi XriMZN这样的文件夹里会有真正的文件,然后把文件移出就好了 阅读全文
摘要:
linux 内核参数优化 Sysctl命令及linux内核参数调整 一、Sysctl命令用来配置与显示在/proc/sys目录中的内核参数.如果想使参数长期保存,可以通过编辑/etc/sysctl.conf文件来实现。 命令格式: sysctl [-n] [-e] -w variable=value 阅读全文
摘要:
需求:DB2工程师 工作地点:杭州,合肥 请发简历到7214218@qq.com 阅读全文
摘要:
Restrictions for high availability disaster recovery (HADR)https://www.ibm.com/docs/en/db2/11.1?topic=server-high-availability-disaster-recovery-hadrT 阅读全文
摘要:
"FedStart Failed" message appears in db2diag.log periodically Troubleshooting Problem "FedStart Failed" is reported in db2diag.log at certain interval 阅读全文
摘要:
每天一条DB2命令-036#检查数据库的表状态(输出结果为0正常)db2 "select substr(tabschema,1,10) as tabschema,substr(tabname,1,30) as tabname,available from sysibmadm.admintabinfo 阅读全文
摘要:
https://www.ibm.com/support/pages/removing-ibm-db2-temporary-files-failed-db2-load-operation Support DownloadsDocumentationForumsCasesMonitoringManage 阅读全文
摘要:
IT31613: UNNECESSARY SQLO_BAD_USER LOGGING INTO DB2DIAG.LOGhttps://www.ibm.com/support/pages/apar/IT31613A fix is availableDb2 Version 11.1 Mod 4 Fix 阅读全文
摘要:
分析20220302:2022-03-01-16.08.02.835487+480 E4669090A740 LEVEL: Error (OS)PID : 7144388 TID : 1 PROC : db2stopINSTANCE: db2iacrm NODE : 000EDUID : 1FUNC 阅读全文