# DB2 commonly used fool problem

xiaoxiao2021-04-08  4

DB2 commonly used fool problem 1000 asked (五)

Everyone may encounter some seemingly simple questions when applying DB2, especially for newcomers, I have a simple summary, release it to everyone, I hope everyone can help, and also welcome everyone to discuss. Common development, common progress! The following mainly based on DB27.x. The following characters are lowercase. This article is not read for DB2 masters. DB2 functions 135.avg () returns a set of values. Selectavg Salary) fromBSempms; 136.corr (), correlation () returns a relational coefficient of a pair of values. SelectCorRelation (Salary, Bonus) fromBSempms; 137.count () Returns a number of rows or values. SelectCount (*) fromBSempms; 138.covar (), COVARIANCE () Returns a covariance of a pair of values. SELECTCOVAR (Salary, Bonus) fromBSempms; 139.max () Returns the maximum value in a set of values. Selectmax (Salary) fromBSempms; 140.min () Returns a minimum of a set of values. Selectmin (Salary) fromBSempms; 141.stddev () Returns the standard deviation of a set of values. Selectstddev (Salary) fromBSempms; 142.sum () Returns a set of data and. SelectSum (Salary) "143.VAR (), variance () returns a variance of a set of values. Selectvariance (Salary) fromBSempms; 144.abs (), absval () returns an absolute value of the parameter. Selectabs (-3.4) fromBSempms; 145.acos ) Returns the anti-cosrome value of the parameter. Selectacos (0.9) fromBSempms; 146.ascii () Returns the ASCII code of the leftmost character of the integer parameter. Selectascii ('r') fromBSempms; 147.asin () Returns the angle representation of the arc The argument of the anti-stereo function. SELECTASIN (0.9) fromBSempms; 148.atan () Returns an intermediate cut value of the parameter, this parameter The arc parameters represent the angle of the angle. Selectatan (0.9) fromBSempms;

DB2 commonly used fool problem 1000 asked (four)

100. How to delete the sequence? Dropsequencesequence_name 101.db2 supports import (import) file format Is it: Del, ASC, IXF, WSF, etc. 102.DB2 Support Export (export) file format? Has: Del, IXF, WSF The ASC format is not supported. 103.DB2 Support load (LOAD) file format Is it: Del, ASC, IXF, etc. Does not support WSF format. 104.DB2 Support DB2MOVE file format Is there: IXF, etc. ASC, DEL, WSF format. 105.DB2 Database Monitoring two components? SnapshotMonitor can return a snapshot of database activity of a specific time point. Event monitor (EventMonitor) Record the data generated by the event. 106. System The monitoring data element type? Counter records the number of times of activity. The current value of the Gauge measurement entries. Watermark is the maximum or minimum value of the elements from monitoring. Information (Information) monitoring activities Type details. Timestamp activity The date time occurred. Time (time) returns a time taken. 107. How do I know the number of pages needed to monitor the heap? (NumberofMonitoringApplications 1) * (NumberofDatabases * (800 (NUMBEROFTABLES ACCESSED * 20) ((NUMBEROFAPPLICATIONSCONNECTED 1) * (200 (NUMBEROFTABLE SPACES * 100))))) / 4096 by its size parameters MON_HEAD_SZ control 108. how to create an event monitor CREATEEVENTMONITORTABLEMONFORTABLESWRITETOFILE'D:.? / TEMP '109. How to activate the event monitor? STEVENTMONITORTABLEMOMOSTATATE1 110. How to stop the event monitor? SetEventMonitorTableMonState0 111. How to query the status of the monitor? SELECTEVMONNAME, EVENT_MON_STATE (EVMONNAME) fromsyscat.EventMonitors ? 112. How to delete event monitors to create a pipe event monitor on DROPEVENTMONITORTABLEMON 113.UNIX and WINDOWS (PIPE meaning EVNT see MONITOR) of different first step:? Define an event monitor UNIX: CONNECTTOSAMPLE CREATEEVENTMONITORSTMB2FORSTATEMENTSWRITETOPIPE '/ TMP / EVPIPE1' WINDOWS: CONNECTOSMPLE CREATEEVENTMONITORSTMB2FORSTATEMENTSWRITOPIPE '/ / / TMP / EVPIPE1'

Step 2: Establish a named pipeline UNIX: You can use the mkfifo () function or mkfifo command. Windows: You can use the CreateNameDpipe () function, the pipe name is the same name with the CreateEventMonitor specified. Step 3: Open Name Pipeline Unix: Use the open () function Windows: Using the connectNamedPipe () function. You can also use the db2evmon command, such as: DB2EVMON-dbsample-evmstmb2 Step 4: Activate Name Pipe Event Monitor Unless automatically activates the named pipe event monitor, setEventMonitorstMB2State1 Step 5: From Named Pipeline Read Data Unix: You can use the read () function. Windows: You can use the readfile () function. Step 6: Stop event monitor setEventMonitorstMB2State0 Step 7: Close Name Division Unix: You can use a close () function. Windows: you can use DISCONNECTNAMEDPIPE () function. Eight step: Delete Named Pipeline Unix: You can use a unlink () function. Windows: You can use a CloseHandle () function. 114.DB2 SQL statement Category? DCL: Data Control Language, provide database objects Access rights. DDL: Data Definition Language, Create, Modify, Delete Database Objects. DML: Data Manipulation Language, Used to Insert, Update, Delete Data. [Page] 115.DCL Who? Control Permissions: If users Create an object, then change the user fully access the object. The GRANT statement grants permissions to the user. The REVOKE statement revokes the permissions of a user. What are the 117.dml of CREATE DECLARE ALTER DROP? Insert SELECT UPDATE DELETE Waiting for 118.db2 Is there a Boolean type? No 119. How to query the built-in function of DB2? Free Document Administration -> SQLReference -> Functions 120. How to perform DB2 script file? DB2-vtffilename 121.db2 in Oracle Rownum () is? ROW _Number () over () 122.db2 How to get an error code? DB2? SQLCODE 123.DB2 VARCHAR converted to Integer's function? Cast () 124.db2 Integer converted to varchar function? Charr ( 125. DATE Switch to Date () 126.DB2 function "CHAR () 127.DB2 The TRIGGER in CHAR () 127.DB2 can be modified? Cannot, only delete reconstruction 128 .Windows How to know the port number of DB2? / Winnt / System32 / drivers / etc / services 129.db2 How to perform a stored procedure? Can DB2CallProcedure_name 130. How to enter DB2 DOS command mode? DB2CMD 131. How to get DB2 process number? DB2ListApplications 132. How to kill DB2 processes? ForceApplication (ID) 133.A User After installing DB2, how to start Database with B users? Plus. Plus in .Profile ./Home_DB2inst/sqllib/db2profile 134.db2 Sato-like Snapshots of Oracle? Best_dba Published on June 21, 2006 Reviews (0) Post a comment

DB2 commonly used fool problem 1000 asked (three)

Everyone may encounter some seemingly simple questions when applying DB2, especially for newcomers, I have a simple summary, release it to everyone, I hope everyone can help, and also welcome everyone to discuss. Common development, make progress together!

The following mainly based on DB27.x. The following characters are lowercase. This article is not read for DB2 masters. All characters are lowercase. 91. How to create a profile of DB2? DB2's profile function is similar to Oracle ! materialized view syntax is: CREATESUMMARYTABLETABLE_NAMEAS (fULLSELECT) ... For example: define a refresh summary tables can be:. CREATESUMMARYTABLETABLE_NAMEAS (SELECT * FROMTABLE_NAME1WHERECOL1 = AAA) DATAINITIALLYDEFERREDREFRESHDEFERRED wherein DATAINITIALLYDEFERRED predetermined data can not be inserted into the table as part of the statement of REFRESHDEFERRED predetermined CREATETABLE The data in the table can be refreshed when any RefreshTable statement is used! 92. How to refresh the overview? REFRESHTABLESUM_TABLE where SUM_TABLE is a profile. 93. How to modify the profile? Altertablesum_table ... 94. How to create a temporary table? Syntax: DECLAREGLOBALTEMPORARYTABLETABLE_NAME AS (fULLSELECT) DEFINITIONONLY EXCLUDINGIDENTITYCOLUMNATTRIBUTES ONCOMMITDELETEROWS NOTLOGGED first row the name of the temporary table of predetermined second line defines a predetermined temporary table column. the third line defines the results are not copied from the source table definition column of the identity fourth predetermined row If you do not open WITHGOLD cursor will delete all the rows in the table to change the provisions of the fifth row of the table does not record such as:.. DECLAREGLOBALTEMPORARYTABLEDEC_BSEMPMS AS (SELECT * FROMBSEMPMS) management DEFINITIONONLY EXCLUDINGIDENTITYCOLUMNATTRIBUTES ONCOMMITDELETEROWS NOTLOGGED 95. view of how to create a view:? CREATEVIEWVIEW_NAMEASSELECT * FROMTABLE_NAMEWHERE ... Delete View: DropViewView_name 96. How do I know the contents of the view definition? Sext in Seter, Serext *,. ​​97. How to create an alias? Createaliasalias_nameforpro_name Pro_Name can be Table, View, Alias, Nickname, etc. 98. How to create a sequence? For example: createquencedsequence_name StartwithStart_Number IncrementByvalue1 NomaxValue NOCYCLEMAXIMUMNUMBEROFSEQUENCEVALUES Name of the first line specified sequence. The second line specifies the start value of the sequence. The third line stipulates the new range. The fourth line requires no maximum numerical limit. 99 How to change the sequence? AltersequenceSequence_name ... You can modify the parameter startwith's Start_Number Increment Value1 NomaxValue NOCYCLEVALUMUMNUMBEROFSEQUENCEVALUES Maximum value BEST_DBA Published on June 21, 2006 Comments (0) Published comments

DB2 commonly used fool problem 1000 asked (2)

Everyone may encounter some seemingly simple questions when applying DB2, especially for newcomers, I have a simple summary, release it to everyone, I hope everyone can help, and also welcome everyone to discuss. Common development, common progress! The following mainly based on DB27.x. The following characters are lowercase.