DB2 - 随笔分类(第2页) - 红色MINI

Why am I getting a DIA8411C A file "" could not be found in the db2diag.log?

摘要：IBM Support Why am I getting a DIA8411C A file "" could not be found in the db2diag.log? https://www.ibm.com/support/pages/why-am-i-getting-dia8411c-f 阅读全文

posted @ 2022-12-26 11:51 红色MINI 阅读(173) 评论(0) 推荐(0) 编辑

关于docker容器-ibmcom/db2-amd64

摘要：关于docker容器- ibmcom/db2-amd64 Verified Publisher By IBM • Updated 2 months ago Db2 - The AI Database Image Pulls10K+ OverviewTags IBM® Db2® is a multi- 阅读全文

posted @ 2022-12-22 07:54 红色MINI 阅读(79) 评论(0) 推荐(0) 编辑

DB2 on Apple Silicon

摘要：DB2 on Apple Silicon https://www.triton.co.uk/db2-on-apple-silicon/ Apple’s Macs have been a popular development platform for many years now, but IBM 阅读全文

posted @ 2022-12-22 07:52 红色MINI 阅读(39) 评论(0) 推荐(0) 编辑

Fix List for DB2 Version 10.1 for Linux, UNIX and Windows

摘要：IBM Support Fix List for DB2 Version 10.1 for Linux, UNIX and Windows Troubleshooting https://www.ibm.com/support/pages/fix-list-db2-version-101-linux 阅读全文

posted @ 2022-12-07 09:14 红色MINI 阅读(37) 评论(0) 推荐(0) 编辑

What does SQLJC_ERROR_SYNTAX error mean and how to resolve it?

摘要：IBM Support What does SQLJC_ERROR_SYNTAX error mean and how to resolve it? https://www.ibm.com/support/pages/what-does-sqljcerrorsyntax-error-mean-and 阅读全文

posted @ 2022-12-07 09:11 红色MINI 阅读(34) 评论(0) 推荐(0) 编辑

Connection attempt to a database may return SQL0902C error with reason code "200x1232"("0100")""

摘要：Skip to content Support DownloadsDocumentationForumsCasesMonitoringManage support account IBM Support Connection attempt to a database may return SQL0 阅读全文

posted @ 2022-12-07 09:00 红色MINI 阅读(131) 评论(0) 推荐(0) 编辑

IC64525: SQLCODE -30020 OR DRDA DATA STREAM SYNTAX ERROR REPORTED BY DB2 CONNECT SERVER after a TCP/IP error is reported.

摘要：Skip to main content Open a case Known Issues IC64525: SQLCODE -30020 OR DRDA DATA STREAM SYNTAX ERROR REPORTED BY DB2 CONNECT SERVER after a TCP/IP e 阅读全文

posted @ 2022-12-07 08:59 红色MINI 阅读(60) 评论(0) 推荐(0) 编辑

Why does a db2agent return "No memory available in 'Database Monitor Heap'"?

摘要：Skip to content Support DownloadsDocumentationForumsCasesMonitoringManage support account IBM Support Why does a db2agent return "No memory available 阅读全文

posted @ 2022-12-06 10:34 红色MINI 阅读(45) 评论(0) 推荐(0) 编辑

Migrating DB2 from little endian Linux to big endian AIX

摘要：IBM and AWS: Build a better architecture for your business.Learn more IBM Developer Topics Products & Services Community Open source at IBM Search IBM 阅读全文

posted @ 2022-12-01 10:29 红色MINI 阅读(86) 评论(0) 推荐(0) 编辑

CDC 关于Identity columns

摘要：InfoSphere Data Replication 11.3.3 FeedbackProduct list Identity columns https://www.ibm.com/docs/en/idr/11.3.3?topic=luw-creating-database-backup Las 阅读全文

posted @ 2022-11-29 15:29 红色MINI 阅读(21) 评论(0) 推荐(0) 编辑

IT25589: LIST HISTORY COMMAND FAILS WITH DB21018E ERROR WHEN THE HISTORY FILE CONTAINS A DROPPED TABLE EVENT WITH LONGER TABLE NAME.

摘要：Known Issues https://www.ibm.com/mysupport/s/defect/aCI3p000000kF7p/dt159458?language=en_US IT25589: LIST HISTORY COMMAND FAILS WITH DB21018E ERROR WH 阅读全文

posted @ 2022-11-10 15:10 红色MINI 阅读(173) 评论(0) 推荐(0) 编辑

db2 表压缩

摘要：#表压缩db2 "ALTER TABLE CUSTOMER COMPRESS YES ADAPTIVE"#立即启用压缩db2 "reorg table CUSTOMER" db2 "reorg table CUSTOMER resetdictionary"这个参数干嘛用的建立压缩字典如果你认为文阅读全文

posted @ 2022-09-09 21:31 红色MINI 阅读(254) 评论(0) 推荐(0) 编辑

Warning message "Partial Early Aggregation/Distinct running with reduced memory"

摘要：Warning message "Partial Early Aggregation/Distinct running with reduced memory" https://www.ibm.com/support/pages/warning-message-partial-early-aggre 阅读全文

posted @ 2022-09-03 01:39 红色MINI 阅读(24) 评论(0) 推荐(0) 编辑

ROLLFORWARD DATABASE command

摘要：ROLLFORWARD DATABASE command https://www.ibm.com/docs/en/db2/11.1?topic=commands-rollforward-database Last Updated: 2022-06-17 The ROLLFORWARD DATABAS 阅读全文

posted @ 2022-09-02 10:49 红色MINI 阅读(36) 评论(0) 推荐(0) 编辑

HADR有关LOAD及REORG操作

摘要：HADR有关LOAD及REORG操作LOAD使用 COPY YES 选项在主数据库上执行LOAD操作，并且通过 LOAD 命令指定的路径或设备能被备用数据库访问，那么数据将复制到备用数据库。如果备用数据库无法访问数据，在备用数据库中会记为无效。备用数据库将跳过与此表空间相关的日志记录。要确保LOAD 阅读全文

posted @ 2022-08-30 22:26 红色MINI 阅读(242) 评论(0) 推荐(0) 编辑

DB2_LOAD_COPY_NO_OVERRIDE and controlling non-recoverable load operations

摘要：DB2_LOAD_COPY_NO_OVERRIDE and controlling non-recoverable load operations https://www.ibm.com/support/pages/db2loadcopynooverride-and-controlling-non- 阅读全文

posted @ 2022-08-30 22:23 红色MINI 阅读(112) 评论(0) 推荐(0) 编辑

数据库死锁监视器清理变更

摘要：数据库死锁监视器清理变更一．清理数据库死锁监控日志操作涉及主机：主机名（IP） (请修改以下文档的实例名、路径等)1、查看设置的事件监视器db2 "select substr(evmonname,1,20) as evmonname,substr(owner,1,10) as owner,ow 阅读全文

posted @ 2022-08-29 14:50 红色MINI 阅读(102) 评论(0) 推荐(0) 编辑

IT08458: NON-OPTIMAL ACCESS PLAN MIGHT BE GENERATED FOR A COMPLEX QUERY THAT PRODUCES A SQL0437W WITH RC=1

摘要：IT08458: NON-OPTIMAL ACCESS PLAN MIGHT BE GENERATED FOR A COMPLEX QUERY THAT PRODUCES A SQL0437W WITH RC=1 https://www.ibm.com/support/pages/apar/IT08 阅读全文

posted @ 2022-08-10 21:38 红色MINI 阅读(32) 评论(0) 推荐(0) 编辑

Table space states

摘要：Table space states https://www.ibm.com/docs/en/db2/11.1?topic=spaces-table-space-states Last Updated: 2022-05-20 This topic provides information about 阅读全文

posted @ 2022-06-22 13:47 红色MINI 阅读(26) 评论(0) 推荐(0) 编辑

每天一条DB2命令-039

摘要：每天一条DB2命令-039#对index授权db2 grant index on table BANKUSER.PCIF to user nas_rw 阅读全文

posted @ 2022-06-22 11:30 红色MINI 阅读(7) 评论(0) 推荐(0) 编辑

红色MINI

随笔分类 - DB2