Db2

Showing 1347

EXPORT to local (not server) using the ADMIN_CMD

The export calle from admin_cmd can only export to the server. There should be a way to export in the client when called the SP,

over 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

2 VOTE

CTAS locks syscat.tables

Reproduce Scenario and found to be a expected behavior while CTAS locks syscat.tables session 1 > create table Table1 as (select * from Table_2 ) with data; session 2, query tool > select * from syscat.tables; --> lock waiting

over 4 years ago in Db2 / Other/Unknown 0 Not under consideration

2 VOTE

HADR PS MEM restore

背景：HADR+PS环境，主端ps的mem0节点宕机无法恢复，利用新设备以mem0的身份加入集群问题：当新设备以mem0身份加入时报错，由于集群拓扑结构发生变化数据库处于inconsistent状态，所以无法将MEM0重新加入，当拓扑结构发生变化时不应该影响数据库的一致性；

over 4 years ago in Db2 / High Availability and/or Disaster Recovery 1 Not under consideration

2 VOTE

Deploy new/unused packages without causing performace impacts

With current DB2(V11.1 FP2, FP4), Deploying a new or an unused packages causing variation and catalog locks impacting performance. HOLDHDL WAITHDL HOLDER WAITER HOLDMODE OBJTYPE TABNAME SCHEMA SECS STMTTEXT ---------- ------- ---------- ----...

over 4 years ago in Db2 / Application Development 0 Not under consideration

2 VOTE

Allow better monitoring of DB2 Thread/Connection types

Currently there are various ZPARMs to "control" thread management (CTHREAD,MAXDBAT,CONDBAT,IDFORE,IDBACK,etc). These ZPARMS are upper bound limits of the number of each type of thread/connection that DB2 is configured with. There is very little in...

over 4 years ago in Db2 / Monitoring 0 Not under consideration

2 VOTE

Export should have nocoldel or coldelx20

Db2 should allow an export without characters for columns not characters, or space as column delimiter. Something like: export to myfile.csv of del modified by nochardel nocoldel select * from mytable There is something to change the col...

almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

2 VOTE

Multiple index creation in parallel in the AMT

AMT procedure is used for online reorg. At index build phase, parallel multiple index creation is needed for faster completion of job.

almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

2 VOTE

ALTER INDEX disable/enable feature

Oracle supports disabling index in ALTER INDEX command. Disabling an index means that the index still exists in the database, but it is not included in the optimizer. It would be also helpful in Db2 when find out the optimal Index.

almost 5 years ago in Db2 / Statements (DDL and DML) 1 Not under consideration

2 VOTE

Save exceptions in FORALL statement (PLSQL)

Oracle PL/SQL supports save exceptions in FORALL statement, but Db2 PL/SQL doesn't. For smooth oracle migration, the feature is required .

almost 5 years ago in Db2 / Application Development 0 Not under consideration

2 VOTE

Adding enableWLB via command db2cli writcfg add -dsn <alias> -parameter "enableWLB=true"

As discussed in PMR 01458,999,724 adding enableWLB parameter with "db2cli writecfg add..." is a known limitation.Could you please remove this limitation. Workaround is to edit XML-file db2dsdriver.cfg manually.

about 5 years ago in Db2 / Db2 Connect and Drivers 1 Not under consideration

Please enter your email address

FILTER BY CATEGORY