Looking at the DB2 tutorial is: DB2 common fool question 1000 Q (iv). 100. How do I delete a sequence?
Dropsequencesequence_name
101.DB2 the file format that supports importing (import) has?
There are: del,asc,ixf,wsf, etc.
102.DB2 the file format that supports exporting (export) has?
There are: Del,ixf,wsf and so on.
The ASC format is not supported.
103.DB2 support Load (load) file formats are available?
There are: DEL,ASC,IXF and so on.
WSF format is not supported.
104.DB2 support for Db2move file format?
There are: IXF and so on.
ASC,DEL,WSF format is not supported.
105.DB2 the two components of database monitoring?
Snapshot monitoring (Snapshotmonitor) returns a snapshot of the database activity at a specific point in time.
Event Monitoring (Eventmonitor) records the data in which the event occurred.
106. What types of data elements are monitored by the system?
Counter (COUNTER) to record the number of times the activity occurred.
Measure (gauge) The current value of a measure entry.
Watermark (watermark) The maximum or minimum number of elements reached from the monitor.
Information (information) monitors the details of the activity's reference type.
Date time that the Point-in-time (TIMESTAMP) activity occurred.
Time returns the time that an activity took.
107. How do I know the number of pages required for the monitoring heap?
(numberofmonitoringapplications+1) * (numberofdatabases* 800+ (numberoftables
ACCESSED*20) + ((numberofapplicationsconnected+1) * (200+ numberoftable
spaces*100)))/4096
Its size is controlled by the parameter MON_HEAD_SZ.
108. How to build Event monitor?
Createeventmonitortablemonfortableswritetofile ' D:\TEMP '
109. How do I activate the event monitor?
SETEVENTMONITORTABLEMONSTATE1
110. How do I stop the event monitor?
SETEVENTMONITORTABLEMONSTATE0
111. How to query the status of the monitor?
Selectevmonname,event_mon_state (Evmonname) fromsyscat. Eventmonitors
112. How do I remove the event monitor?
Dropeventmonitortablemon
113.UNIX the difference between creating a pipe event monitor (pipe evnt see Monitor) on Windows?
First step: Define Event Monitor
Unix:
Connecttosample
Createeventmonitorstmb2forstatementswritetopipe '/tmp/evpipe1 '
Windows:
Connecttosample
Createeventmonitorstmb2forstatementswritetopipe ' \\.\tmp\evpipe1 '
Step two: Establish Named pipes
Unix:
You can use the Mkfifo () function or the Mkfifo command.
Windows:
You can use the CreateNamedPipe () function, which has the same pipe name as the Createeventmonitor rule name.
Step three: Open Named pipes
Unix:
Use the open () function.
Windows:
Use the Connectnamedpipe () function.
You can also use the Db2evmon command, such as:
Db2evmon-dbsample-evmstmb2
Step Fourth: Activate the named pipe Event Monitor
Unless the named pipe Event Monitor is activated automatically,
Seteventmonitorstmb2state1
Step Fifth: Read data from Named pipes
Unix:
You can use the Read () function.
Windows:
You can use the ReadFile () function.
Step Sixth: Stop the event monitor
Seteventmonitorstmb2state0
Step seventh: Close the named pipe
Unix:
You can use the close () function.
Windows:
You can use the Disconnectnamedpipe () function.
Step eighth: Delete Named pipes
Unix:
You can use the unlink () function.
Windows:
You can use the CloseHandle () function.
114.DB2 The SQL statement of the class?
DCL: A Data Control language that provides access to database objects.
DDL: Data definition language, creating, modifying, and deleting database objects.
DML: A data manipulation language used to insert, update, and delete data.
Current 1/2 page
12 Next read the full text
