DB2
yinghuabanwo
天行健 君子以自强不息
14年oracle dba
oracle/mysql/postgresql/tidb/oceanbase/gbase/opengauss/db2
转型国产化ing
展开
-
shadow tables
A shadow table is a column-organized copy of a row-organized table that includes all columns or a subset of columns. Shadow tables are implemented as materialized query tables (MQTs) that are maintained by replication.Using shadow tables, you can get the原创 2020-11-09 10:59:02 · 187 阅读 · 0 评论 -
Parameters in DB2 SQL procedures
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.sqlpl.doc/doc/c0020495.html原创 2020-11-09 09:26:58 · 80 阅读 · 0 评论 -
HADR
HADR不支持双活,pureScale支持双活High availability disaster recovery (HADR) in Db2 pureScale environmentshttps://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.ha.doc/doc/c0061084.html原创 2020-11-08 21:19:20 · 141 阅读 · 0 评论 -
create index
The INCLUDE clause, applicable only on unique indexes, specifies additional columns to be appended to the set of index key columns. Any columns included with this clause are not used to enforce uniqueness. These included columns can improve the performance原创 2020-11-07 20:49:57 · 75 阅读 · 0 评论 -
Read stability (RS)
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.perf.doc/doc/c0004121.html#c0004121__rs原创 2020-11-07 15:40:32 · 83 阅读 · 0 评论 -
extended row size
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061057.html原创 2020-11-07 15:36:16 · 93 阅读 · 0 评论 -
trusted context
The trust relationship is based upon the following set of attributes:System authorization ID: Represents the user that establishes a database connectionIP address (or domain name): Represents the host from which a database connection is establishedData原创 2020-11-07 15:29:20 · 89 阅读 · 0 评论 -
trigger
INSTEAD OF triggers describe how to perform insert, update, and delete operations against complex views. INSTEAD OF triggers allow applications to use a view as the sole interface for all SQL operations (insert, delete, update and select)。INSTEAD OF触发器描述了原创 2020-11-07 14:48:57 · 107 阅读 · 0 评论 -
DB2 compatibility DB2_COMPATIBILITY_VECTOR
DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)A. OracleB. SybaseC. NetezzaD. MongoDBE. Micros原创 2020-09-17 09:26:01 · 203 阅读 · 0 评论 -
DB2 BLU acceleration fundamental
Which of the following is fundamental to BLU acceleration?A. pureScaleB. Column organized tablesC. Multidimensional clusteringD. Purchasing new hardware that is compatible with BLU acceleration and compressionhttp://www.redbooks.ibm.com/abstracts/tips原创 2020-09-16 10:30:50 · 131 阅读 · 0 评论 -
DB2 get_privileges
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)A. db2look with the –x optionB. db2pd with the –auth optionC. Query the SYSCAT.DBAUTH viewD. Query the SYSCAT.TABLES viewE. Query the SYSCAT.TABAUTH viewhtt原创 2020-09-16 09:52:03 · 116 阅读 · 0 评论 -
DB2 pureScale
Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?A. DB2 HADRB. DB2 pureScaleC. DB2 Express-CD. DS2 Database Partitioning FeatureB:https://www.ibm.com/support/kn原创 2020-09-15 22:08:35 · 394 阅读 · 0 评论 -
DB2 create database
Which of the following authorities are sufficient for creating a database? (Choose two.)A. DBADMB. SYSADMC. SECADMD. SYSCTRLE. SYSMAINTcreate database:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r00原创 2020-09-15 20:23:19 · 188 阅读 · 0 评论 -
DB2 create function
What type of function is created using the following command? CREATE FUNCTION TAN (X DOUBLE)RETURNS DOUBLELANGUAGE SQLCONTAINS SQLNO EXTERNAL ACTION DETERMINISTIC RETURN SIN(X)/COS(X)A. RowB. TableC. ScalarD. ExternalCREATE FUNCTION (SQL scalar, t原创 2020-09-15 20:20:57 · 411 阅读 · 0 评论 -
DB2 authorities
Which of the following authorities is sufficient for connecting to a database?A. SQLADMB. CONNECTC. DATAACESSD. ACCESSCTRLhttps://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/c0005524.htmlSQLADMAllows the holde原创 2020-09-15 20:10:54 · 106 阅读 · 0 评论 -
db2 super exclusive(Z) lock
Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)A. No other applications can access the tableB. Only uncommitted read (UR) applications can access the tableC. The lock owner and other applications can read,原创 2020-09-15 20:04:54 · 247 阅读 · 0 评论