text:
Before you start
About this series
If you are preparing to take the DB2 DBA certification exam 731, you've come to the right place -- a study hall, of sorts. This series of seven DB2 certification preparation tutorials covers the major concepts you'll need to know for the test. Do your homework here and ease the stress on test day.
About this tutorial
This tutorial introduces skills you must have to properly manage a DB2 server. This is the fifth tutorial in a series of seven tutorials to help you prepare for the DB2 V9 for Linux, UNIX, and Windows; Database Administration Certification (Exam 731).
In this tutorial, you will learn:
- How to extract data using the
- How to populate tables with the
- The advantages and disadvantages of using
- When and how to use the
db2look, and
- How to use the
REORGCHK, and
REBINDutilities, and the
FLUSH PACKAGE CACHEstatement
- What can be done with the DB2 Control Center
- When and how to use the DB2 Design Advisor
To take the DB2 9 DBA exam, you must have already passed the DB2 9 Fundamentals exam 730. We recommend that you take the DB2 Fundamentals tutorial series before starting this series.
This tutorial is one of the tools to help you prepare for Exam 731. You should also review the resources at the end of this tutorial for more information about DB2 utilities (see Resources).
Although not all materials discussed in the Fundamentals tutorial series are required to understand the concepts described in this tutorial, you should at least have a basic knowledge of:
- DB2 products
- DB2 tools
- DB2 instances
- Databases
- Database objects
System requirements
You do not need a copy of DB2 to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of IBM DB2 9 to work along with this tutorial.
Data movement utilities
Utilities and file formats
Three data movement utilities are available in DB2:
It is important to make sure that the data you want to transfer is compatible with both the source and target platforms. File formats supported by the utilities are:
- Non-delimited or fixed-length ASCII (ASC): As the name implies, this file type contains ASCII data in fixed length to align with column data. Each ASC file is a stream of ASCII characters consisting of data values ordered by row and column. Rows in the data stream are separated by row delimiters, which are assumed to be newline characters.
- Delimited ASCII (DEL): This is the most common file format used by a variety of database managers for data exchange. It contains ASCII data and uses special character delimiters to separate column values. Rows in the data stream are separated by a newline character as the row delimiter.
- PC version of the Integrated Exchange Format (PC/IXF): This is a structured description of a database table. This file format can be used not only to import data but also to create a table that does not already exist in the target database.
- Worksheet Format (WSF): Data stored in this format can be interpreted in worksheets. It can be used for export and import only.
- Cursor: A cursor is declared with a query. It can only be used as the input of a load operation.
DB2 EXPORT utility
Overview of the EXPORT utility
EXPORT utility extracts data from database tables to a file using an SQL
SELECT or
XQUERY statement. The exported data can be in the DEL, IXF, or WSF file formats. It is recommended that you include the
MESSAGES clause in the export to capture errors, warnings, and informational messages during the export.
To successfully invoke the
EXPORT utility, you must have SYSADM or DBADM authority, or CONTROL or SELECT privilege on the tables or views being accessed in the
EXPORT command.
With the new label-based access control (LBAC) support introduced in DB2 9.1, you need to pay attention to your LBAC credentials, which may or may not allow you to access protected rows and/or columns. When exporting data from a table that has protected rows, your LBAC credentials might limit the rows that are exported. Rows you don't have read access to will not be exported. No error or warning is given. However, if your LBAC credentials does not allow reading from one or more protected columns included in the export, the export will fail with an error.
Let's look at a simple export example. The command below exports the result of the
SELECT statement to a file in DEL format. The message file
msg.out records useful information as well as any errors or warnings encountered:
EXPORT TO myfile.del OF DEL MESSAGES msg.out SELECT staff.name, staff.dept, org.location FROM org, staff WHERE org.deptnumb = staff.dept;
File type modifiers
In the example on the previous panel, data is extracted to a file in DEL format. By default, column values are separated by commas (
,) and character strings are enclosed by double quotation marks (
"). What if the data to be extracted already contains commas and double quotes? It will then be impossible for the import or load utility to determine which symbols are actual data and which are delimiters. To customize how
EXPORT operates, you can use the
MODIFIED BY clause and specify what you want to change with file type modifiers. The
EXPORT command with the
MODIFIED BY clause will look like this:
EXPORT TO file_name OF file_type MODIFIED BY file_type_modifiers MESSAGES message_file select_statement
A complete listing of the file type modifiers can be found in the Command Reference Guide, under
EXPORT. Some commonly used modifiers are listed here for demonstration:
- Specify
xto be the new single character string delimiter. The default value is a double quotation mark (
- Specify
- Specify
xto be the new single character column delimiter. The default value is a comma (
- Specify
- Specify
x, an ASCII character string, to be the new code page of the output data. During the export operation, character data is converted to this code page from the application code page.
- Specify
xis the format of the time stamp in the source table.
Consider this example:
EXPORT TO myfile.del OF DEL MODIFIED BY chardel! coldel@ codepage=1208 timestampformat="yyyy.mm.dd hh:mm tt" MESSAGES msg.out SELECT * FROM schedule
The command above exports data from the SCHEDULE table in DEL format with the following behavior:
- Character strings are enclosed by the exclamation mark (
- Columns are delimited by the
- Character strings are converted to code page 1208
- The user-defined timestamp in the SCHEDULE table has a format of yyyy.mm.dd hh:mm tt
Exporting large objects with the
LOBSINFILE modifier
When exporting tables with large object columns, by default only the first 32 KB of LOB data is exported. This part of the object is placed in the same file as the rest of the column data. To export the LOB data in full and store them in files different from the other column data, you must use the LOB options. In DB2 V9.1, you can specify whether you want multiple LOB values to be concatenated and exported in the same output file or each LOB value to be exported to a separate file.
Below is an
EXPORT command with the
LOBSINFILE modifier which causes the export utility to write multiple LOB values in the same output file.
EXPORT TO file_name OF file_type LOBS TO lobfile_directory_1, lobfile_directory_2, ... LOBFILE lobfilename MODIFIED BY LOBSINFILE MESSAGES message_file select_statement
LOBS TO clause specifies the directories in which the LOB files will be stored. If no
LOBS TO clause is found, LOB data is sent to the current working directoy. Notice from the command above that you can specify more than one path as the LOB file target directories. There will be at least one file per LOB path, and each file will contain at least one LOB.
It is probably helpful to identify the extracted LOB files with user-specified file names. The
LOBFILE clause can be used for this purpose. Each LOB file will have a sequence number as the file extension (e.g.,
lobfile.003, etc.).
When either the
LOBS TO or
LOBFILE option is specified, the
LOBSINFILE behavior will be implicitly activated. However, it is always a good practice to explicitly specify the
LOBSINFILE modifier to avoid confusion with the
LOBSINSEPFILES modifier behavior which will be discussed later.
LOB Location Specifier
When exporting large objects with the
LOBSINFILE modifier, a LOB Location Specifier (LLS) is generated and stored in the export output file. The LLS is a string used to indicate where LOB data can be found. It has a format of
filename.ext.lob.nnn.mmm/. Let's look at that in more detail:
filename.ext.lobis the name of the file that contains the LOB data.
extis a sequence number, as described in the previous panel.
nnnis the offset of the large object within the LOB file in bytes.
mmmis the length of the large object in bytes.
For example, an LLS of
resume.001.lob.1257.2415/ indicates that the large object is located in the file
resume.001.lob, that the actual LOB data begins at an offset of 1257 bytes of the file, and that it is 2,415 bytes long.
To clearly illustrate how LLS is used, examine the example below.
EXPORT TO empresume.del DEL LOBS TO d:\lob1\ LOBFILE resume MODIFIED BY LOBSINFILE MESSAGES msg.out SELECT * FROM emp_resume
Exporting large objects with the
LOBSINSEPFILES modifier
As mentioned in the previous sections, you can also choose to export LOB data in full and store each of them in separate files. The LOB options described earlier remain the same, except that the LOBSINSEPFILES modifier is used instead.
Here is an example with such modifier.
EXPORT TO empresume.del DEL LOBS TO d:\lob1\ LOBFILE resume MODIFIED BY LOBSINSEPFILES MESSAGES msg.out SELECT * FROM emp_resume
With this
EXPORT command, the export utility will write LOB data in files with names resume.ext.lob (i.e. resume.001.lob, resume.002.lob, resume.003.lob, etc.) which are all located in the LOB path d:\lob1.
Exporting XML data
With the introduction of native XML support in DB2 9.1, the export utility is extended to also support XML. If you were to export a table (defined with XML data) without specifying any XML related options, the associated XML data will be written to a file or files separate from the rest of the exported relational data. Let's look at an example. The following
EXPORT command is issued on the PRODUCT table which has one XML column defined:
EXPORT TO prodexport.del DEL MESSAGES msg.out SELECT * FROM product
In this example, the export utility will generate two output files. One of them is the prodexport.del file which contains relational data of the table as well as the XML data specifier (XDS).
XDS is a string represented as an XML tag named "XDS". It has attributes that describe information about the actual XML data in the column. Here are the attributes you might see in an XDS string.
FILspecifies the name of the file that contains the XML data.
OFFspecifies the byte offset of the XML data in the file named by the FIL attribute.
LENspecifies the length in bytes of the XML data in the file named by the FIL attribute.
SCHspecifies the fully qualified SQL identifier of the XML schema used to validate this XML document. This attribute will be discussed in the next panel.
From the content of prodexport.del above, you can see that the first XML data is stored in prodexport.del.001.xml starting at 0 byte offset and it has a length of 252 bytes.
The other file generated by the export utility in this example is prodexport.del.001.xml which contains the XML content. Every XML data exported are concatenated and written to this file. Here is the content of the prodexport.del.001.xml file to give you a better idea.
Exporting XML data with XML options and modifiers
Like exporting large objects, you can specify the path(s) where the exported XML documents will go and the base filename of the output files. Consider the following example:
EXPORT TO prodexport.del DEL XML TO d:\xmlpath XMLFILE proddesc MODIFIED BY XMLINSEPFILES XMLNODECLARATION XMLCHAR XMLSAVESCHEMA MESSAGES msg.out SELECT * FROM product
Here, the relational data of the PRODUCT table is exported to the prodexport.del file. All XML data is then written in the directory specified in the
XML TO clause, d:\xmlpath. The files with XML data are named proddesc.ext.xml where ext is a sequence number (e.g., proddesc.001.xml, proddesc.002.xml, proddesc.003.xml, etc.). This base filename is defined with the
XMLFILE option.
You might also notice that a few modifiers are used in the example. Here is a summary of all the XML-related modifiers.
XMLINSEPFILEScauses the export utility to write each exported XML document to a separate XML file.
XMLNODECLARATIONindicates that the XML data is exported without an XML declaration tag. An XML declaration tag is by default written at the beginning of an XML document that includes an encoding attribute.
XMLCHARindicates that the XML data is written in the character codepage. By default, XML data is written out in Unicode. When this modifier is used, the value of the
codepagefile type modifier or the application codepage will be used instead.
XMLGRAPHICindicates that the exported XML data will be encoded in the UTF-16 codepage regardless of the
codepagefile type modifier or the application codepage. Note that
XMLGRAPHICis not used in this example.
The last option we are introducing here is
XMLSAVESCHEMA. When an XML document was inserted, it can be validated against an XML schema. The
XMLSAVESCHEMA option causes the export utility to also save the XML schema information for every exported XML data. A fully qualified SQL identifier of that schema will be stored as an SCH attribute inside the corresponding XML data specifier (XDS). Note that if the exported XML document was not validated against an XML schema or the schema object no longer exists in the database, an SCH attribute will not be included in the corresponding XDS.
The following shows you the result of the above export example.
Exporting XML data with an XQuery
EXPORT command also allows you to specify an XQuery statement so that the export utility writes the result of an XQuery to an XML file. Let's examine the following example.
EXPORT TO custexport.del DEL XML TO d:\xmlpath XMLFILE custphone MODIFIED BY XMLINSEPFILES XMLNODECLARATION MESSAGES msg.out SELECT XMLQUERY ('$doc/customerinfo/phone' PASSING INFO AS "doc") FROM customer
The XQuery in the above example returns all the phone numbers for every customer stored in the CUSTOMER table under the XML column INFO. All the XML options and modifiers discussed apply to XQuery statements. Hence, this example will generate separate XML documents for each result of the XQuery. The files are located in d:\xmlpath and they are named custphone.ext.xml where ext is a sequence number. In addition, no XML declaration tag will be included in the documents.
Here is the content of one of the exported XML documents.
Exporting from the Control Center
In addition to executing the
EXPORT command from the DB2 command line, you can export using the Control Center. From this tool, it is possible to specify all the options and clauses supported by the export such as the large objects and XML data. As illustrated in the figure below, the Schedule tab allows you to create a task and schedule the export to run at a given time.
DB2 IMPORT utility
Overview of the IMPORT utility
IMPORT utility populates data into a table with an input file in a file type of ASC, DEL, IXF, or WSF. The target can be a table, a typed table, or a view. However, imports to system tables, temporary tables, and materialized query tables are not permitted. It is also recommended that you use the
MESSAGES clause so that errors, warnings, and informational messages are recorded.
To successfully import data, you must have SYSADM or DBADM authority, or underlying privileges (SELECT, INSERT, CONTROL, or CREATETAB) on the target table or database, depending on which option you use. To import data into a table that has protected rows and columns, you must have LBAC credentials that allow write access to all protected data in the table. In addition, importing to table with protected rows requires that your LBAC credentials is part of the security policy protecting the table.
IMPORT command is shown below with five different options:
IMPORT FROM file_name OF file_type MESSAGES message_file [ INSERT | INSERT_UPDATE | REPLACE | REPLACE_CREATE | CREATE ] INTO target_table_name
- The
INSERToption inserts imported data to the table. The target table must already exist.
- The
INSERT_UPDATEinserts data to the table, or updates existing rows of the table with matching primary keys. The target table must exist with a primary key defined.
- The
REPLACEoption deletes all existing data and inserts imported data to an existing target table.
- With the
REPLACE_CREATEoption, if the target table exists, the utility deletes existing data and inserts new data as if the
REPLACEoption were specified. If the target table is not defined, the table and its associated indexes will be created before data is being imported. As you can imagine, the input file must be in PC/IXF format, because that format contains a structured description of an exported table. If the target table is a parent table referenced by a foreign key,
REPLACE_CREATEcannot be used.
- The
CREATEoption creates the target table and its indexes, then imports data into the new table. The only file format supported is PC/IXF. You can also specify the name of the table space where the new table should be created.
IMPORT FROM emp.ixf OF IXF MESSAGES msg.out CREATE INTO employee IN datatbsp INDEX IN indtbsp
IMPORT options
IMPORT is basically a utility to insert data into a table in bulk. This bulk insert operation is just like a normal insert statement in that the activity is logged, indexes are updated, referential integrity is checked, and table constraints are checked. By default,
IMPORT commits only once, at the end of the operation. If a large number of rows are imported or inserted into the table, sufficient transaction logs are required for rollback and recovery. You can request periodic commits to prevent the logs from getting full. By committing the inserts regularly, you also reduce the number of rows being lost if a failure occurs during the import operation. The
COMMITCOUNT option forces a
COMMIT after a set number of records are imported. You can also specify the
AUTOMATIC option which allows the import internally determines when a commit needs to be performed. The utility will consider issuing a commit to avoid running into log full situation or to avoid lock escalation. Here is an example of how you can use the
COMMITCOUNT option:
IMPORT FROM myfile.ixf OF IXF COMMITCOUNT 500 MESSAGES msg.out INSERT INTO newtable
If for some reason the above command fails during its execution, you could use the message file to determine the last row that was successfully imported and committed. Then, you could restart the import with the
RESTARTCOUNT option. Note that the behavior of the
SKIPCOUNT option is the same as
RESTARTCOUNT. In the command below, the utility will skip the first 30,000 records before beginning the
IMPORT operation.
IMPORT FROM myfile.ixf OF IXF COMMITCOUNT 500 RESTARTCOUNT 30000 ROWCOUNT 100000 MESSAGES msg.out INSERT INTO newtable
In the example, notice that the
ROWCOUNT option is also used. It specifies the number of physical records to be imported. Because the
RESTARTCOUNT option is used, the import utility will skip the first 30,000 records and import the next 100,000 records into the table.
By default, the import utility will acquire an exclusive lock on the target table before any rows are inserted. The exclusive lock is released as soon as the import completes. This is the behavior of the
ALLOW NO ACCESS option. In order to allow concurrent applications to access the table data, you can use the
ALLOW WRITE ACCESS option. Note that this option is not compatible with the
CREATE, or
REPLACE_CREATE import options. Here is an example of the
ALLOW WRITE ACCESS option.
IMPORT FROM myfile.ixf OF IXF ALLOW WRITE ACCESS MESSAGES msg.out INSERT INTO newtable
Importing XML data
To import XML files, use the
XML FROM option to specify one or more paths where XML files are stored. Otherwise, the import utility will look for the XML files in the current directory. You can choose how the XML documents are parsed; strip whitespace or preserve whitespace. If the
XMLPARSE option is not specified, the parsing behavior for XML documents will be determined by the
CURRENT XMLPARSE OPTION special register. Here is an example of the
XML FROM and
XMLPARSE options
IMPORT FROM myfile.ixf OF IXF XML FROM d:\xmlpath XMLPARSE PRESERVE WHITESPACE MESSAGES msg.out INSERT INTO newtable
When you insert or update an XML document, you might want to determine whether the structure, content, and data types of the XML document are valid. The import utility also supports XML validation through the use of the
XMLVALIDATE option. There are three possible methods.
USING XDS- Recall that you can export XML schema information and store it in the SCH attribute of the XML Data Specifier (XDS). The value of the SCH attribute will be used to perform validation. If there is no SCH attribute in the XDS, either the
IGNORE, or
MAPwill be considered.
USING SCHEMAschema-sqlid - Use the XML schema specified in this clause.
USING SCHEMALOCATION HINTS- Validate the XML documents against the schemas identified by the XML schema location hints in the source XML documents.
IMPORT FROM myfile.ixf OF IXF XML FROM d:\xmlpath XMLPARSE PRESERVE WHITESPACE XMLVALIDATE USING XDS DEFAULT S1.SCHEMA_A IGNORE (S1.SCHEMA_X, S1.SCHEMA_Y, S1.SCHEMA_Z) MAP (S1.SCHEMA_A, S1.SCHEMA_B) COMMITCOUNT 500 RESTARTCOUNT 30000 MESSAGES msg.out INSERT INTO newtable
The above
IMPORT command will:
- Insert data from myfile.ixf and XML files located in d:\xmlpath.
- Whitespace is preserved when the XML document is parsed.
- Each XML document is validated using the schema information identified in the SCH attribute of the XDS. However, if XDS for any particular row doesn't contain a SCH attribute, S1.SCHEMA_A will be used instead.
- For SCH attribute specified as S1.SCHEMA_X, or S1.SCHEMA_Y, or S1.SCHEMA_Z, validation will not be performed for the imported XML document.
- If the SCH attribute is specified as S1.SCHEMA_A, it will then mapped to S1.SCHEMA_B. Note that although the
DEFAULTclause specifies S1.SCHEMA_A, any subsequent mapping will not be performed.
- The import utility will issue a commit after every 500 rows are imported.
- The import operation is started at record 30,001. The first 30,000 records are skipped.
- Any errors, warnings, and informational messages are written to the msg.out file.
- New data are inserted (or appended) into the newtable.
This example only gives you some idea of how the imported XML documents can be validated. There are more examples in the DB2 Information Center that demonstrate the power of the XMLVALIDATE option.
File type modifiers
IMPORT utility also supports file type modifiers to customize the import operation. A complete list of modifiers can be found in the DB2 Command Reference, under
IMPORT. A few of them are outlined here:
- Uses non-atomic compound SQL to insert data.
xnumber of statements will be attempted each time.
- Uses non-atomic compound SQL to insert data.
- Uses the specified schema for the index during index creation.
- Truncates any trailing blank spaces when loading data into a variable-length field.
- Indicates that LOB data is being imported. The utility will check the
LOBS FROMclause to get the path of the input LOB files.
- Indicates that LOB data is being imported. The utility will check the
Here's an example of these file type modifiers in action:
IMPORT FOR inputfile.asc OF ASC LOBS FROM /u/db2load/lob1, /u/db2load/lob2 MODIFIED BY compount=5 lobinsfile INSERT INTO newtable
IMPORT using the Control Center
The Control Center provides easy-to-use graphical interfaces to perform import operations. All the import options and file modifiers discussed in the previous panel are also available in this interface.
DB2 LOAD utility
Overview of the LOAD utility
LOAD utility is another method to populate tables with data. Formatted pages are written directly into the database. This mechanism allows more efficient data movement than the
IMPORT utility. However, some operations, such as referential or table constraints check and triggers invocation, are not performed by the
LOAD utility.
The following is the core of the
LOAD command; other options and modifiers are supported and will be introduced in subsequent panels in this section. To successfully execute this command, you must have SYSADM, DBADM, or LOAD authority, or INSERT and/or DELETE privileges on the table involved in the load. To load data into a table that has protected columns, you must have LBAC credentials that allow write access to all protected columns in the table. To load data into a table that has protected rows, you must have been granted a security label for write access that is part of the security policy protecting the table.
LOAD FROM input_source OF input_type MESSAGES message_file [ INSERT | REPLACE | TERMINATE | RESTART ] INTO target_tablename
The format of a source input for
LOAD can be DEL, ASC, PC/IXF, or CURSOR. A cursor is a result set returned from a
SELECT statement. An example of using CURSOR as the load input is shown here:
DECLARE mycursor CURSOR FOR SELECT col1, col2, col3 FROM tab1; LOAD FROM mycursor OF CURSOR INSERT INTO newtab;
The load target must exist before the utility starts. It can be a table, a typed table, or a table alias. Loading to tables with XML columns, system tables and temporary tables is not supported.
Use the
MESSAGES option to capture any errors, warnings, and informational messages during the load.
LOAD can be executed in four different modes:
- The INSERT mode adds input data to a table without changing the existing table data.
- The REPLACE mode deletes all existing data from the table and populates it with input data.
- The TERMINATE mode terminates a load operation and rolls back to the point in time at which it started. One exception is that if REPLACE mode was specified, the table will be truncated.
- The RESTART mode is used to restart a previously interrupted load. It will automatically continue from the last consistency point. To use this mode, specify the same options as in the previous
LOADcommand but with RESTART. It allows the utility to find all necessary temporary files generated during the load processing. Therefore, it is important not to manually remove any temporary files generated from a load unless you are sure they are not required. Once the load completes without error, the temporary files will be automatically removed. By default they are created in the current working directory. You can specify the directory where temporary files are stored with the
TEMPFILES PATHoption.
Four phases of a load process
A complete load process has four distinct phases.
- Load phase:
- Loads data into the table.
- Collects index keys and table statistics.
- Records consistency points.
- Places invalid data into dump files and records messages in the message file. When rows of data do not comply with the definition of the table, they are considered to be invalid data and will be rejected (not loaded into the table). Use the
dumpfilemodifier to specify the name and location of a file to record any rejected rows.
- Build phase:
- Creates indexes based on the keys collected during the load phase. If
STATISTICS USE PROFILEis specified, statistics is also collected according to the profile defined for the target table. This profile must be created before load is executed, otherwise a warning is returned and no statistics are collected.
- Creates indexes based on the keys collected during the load phase. If
- Delete phase:
- Deletes rows that caused unique key violations and places them in the exception table. Besides data simply doesn't match the definition of the target table as described above, there may be data that passes the load phase but violates a unique constraint defined in the table. Note that only the unique key-violated rows are considered as bad data here; other constraints are not being checked at this time. Since this type of data is already loaded into the table, the
LOADutility will delete the offending rows in this phase. An exception table can be used to store the deleted rows so that you can decide what to do with them after the load operation completes. If no exception table is specified, the offending rows are deleted without a trace. The exception table is discussed in more detail below.
- Records messages in the message file.
- Deletes rows that caused unique key violations and places them in the exception table. Besides data simply doesn't match the definition of the target table as described above, there may be data that passes the load phase but violates a unique constraint defined in the table. Note that only the unique key-violated rows are considered as bad data here; other constraints are not being checked at this time. Since this type of data is already loaded into the table, the
- Index copy phase:
- If
ALLOW READ ACCESSis specified with the
USE TABLESPACEoption, index data is copied from the system temporary table space to the table space where the index should reside.
- If
An exception table is a user-defined table that has to have the same column definition of the target table being loaded. If at least one of the columns is not present in the exception table, the offending rows will be discarded. Only two additional columns can be added to the end of the table: a timestamp column to record when a row is inserted, and a CLOB column to store the reason (or message) why the row is considered bad.
You'll have noticed that some of the concepts presented on this panel haven't been covered in detail yet. We will use some examples and put the pieces together in the rest of the section.
A load example
Let's look at an example to illustrate the steps involved in a load process:
LOAD FROM emp.ixf OF IXF MESSAGES msg.out MODIFIED BY DUMPFILE=c:\emp.dmp TEMPFILES PATH d:\tmp INSERT INTO employee FOR EXCEPTION empexp
- In the diagram above, (1) shows the content of the input source file.
- The target table EMPLOYEE shown in (2) is created with the following column definition:
- The first column must be unique.
- The last column is a numeric column that cannot be NULL.
- An exception table, EMPEXP, shown in (3), is created with the same columns as EMPLOYEE as well as the timestamp and message columns.
In the load phase, all the data from the input file is loaded into EMPLOYEE -- except for the two rows marked in pink, as they do not match with the NOT NULL and NUMERIC column definitions. Since the
DUMPFILE modifier is specified, these are recorded in the file
In the delete phase, the two rows marked in yellow are deleted from EMPLOYEE and inserted into the exception table EMPEXP. This is caused by unique violation of the first column in the EMPLOYEE table.
At the end of the load, you should examine the message file, the dump file, and the exception table, then decide how to deal with the rejected rows. If the load completes successfully, the temporary files generated in
D:\tmp are removed.
Load options and file type modifiers
Some load options and file type modifiers were introduced in the previous panel. A few more are discussed here.
Load options:
ROWCOUNT n: Allows users to specify only the first n records in the input file to be loaded.
SAVECOUNT n: Establishes consistency points after every n rows are loaded. Messages are generated and recorded in the message file to indicate how many input rows were successfully loaded at the time of the save point. This point is not possible when input file type is CURSOR.
WARNINGCOUNT n: Stops the load after n warnings have been raised.
INDEXING MODE [ REBUILD | INCREMENTAL | AUTOSELECT | DEFERRED ]: In the build phase, indexes are built. This option specifies whether the
LOADutility is to rebuild indexes or to extend them increment ally. Four different modes are supported:
REBUILDmode forces all indexes to be rebuilt.
INCREMENTALmode extends indexes with new data only.
AUTOSELECTmode allows the utility to choose between
DEFERREDmode means index create is not going to happen during he load. The indexes involved are marked with refresh required. They will be rebuilt when the database is restated or at the first access to such indexes.
STATISTICS USE PROFILE: After a load is performed, previous statistics of the target table are most likely not valid, as a lot more data has been added. You can choose to collect the statistics in the build phase according to the profile defined for the target table.
File type modifiers. File type modifiers are specified with the
MODIFIED BY clause. Here are few you may find useful:
fastparse: Syntax checking on loaded data is reduced to enhance performance.
identitymissing, and
identityoverride: Used to ignore, indicate missing, or override identity column data, respectively.
indexfreespace n,
pagefreespace n, and
totalfreespace n: Leaves specified amount of free pages in index and data pages.
norowwarnings: Suppresses row warnings.
lobsinfile: Indicates that LOB files are to be loaded; checks
LOBS FROMoption for LOB path.
Table access during load
While a table is being loaded, it is locked by the
LOAD utility with an exclusive lock. No other access is allowed until the load completes. This is the default behavior of the
ALLOW NO ACCESS option. During such a load, the table is in the state of
LOAD IN PROGRESS. There is a handy command that checks the status of a load operation and also returns the table state:
LOAD QUERY TABLE table_name
You may have guessed that there is an option to allow table access. The
ALLOW READ ACCESS option causes the table to be locked in share mode. Readers may access the data that already exists in the table but not the new portion. Data that is being loaded is not available until the load is complete. This option puts the loading table in
LOAD IN PROGRESS state as well as
READ ACCESS ONLY state.
As mentioned in the last panel, a full index can be rebuilt or an index can be extended with the new data during the build phase. With the
ALLOW READ ACCESS option, if a full index is being rebuilt, a shadow copy of the index is created. When the
utility gets to the index copy phase (see Four phases of a load process), the target table is then taken offline and the new index is copied into the target table space.
Regardless of which table access option is specified, various locks are required for the load to process. If the target table is already locked by some application, the
LOAD utility will have to wait until the locks are released. Instead of waiting for a lock, you can use the
LOCK WITH FORCE option in the
LOAD command to force off other applications that hold conflicting locks.
Set Integrity Pending table state
So far, we know that input data that does not comply with the target table definition is not loaded into the table. Such data is rejected and recorded in the message file at the load phase. In the delete phase, the
LOAD utility deletes rows that violated any unique constraints. The offended rows are inserted into an exception table if specified. What about other constraints that the table might have defined, such as referential integrity and check constraints? These constraints are not checked by the
LOAD utility. The table will be placed in
SET INTEGRITY PENDING state, which forces you to manually check data integrity before the table can be accessed. Table state can be queried using the
LOAD QUERY command as discussed in the previous panel. The column CONST_CHECKED in the system catalog table SYSCAT.TABLES also indicates the status of each constraint defined in the table.
To manually turn off integrity checking for one or more tables, use the
SET INTEGRITY command. Examples are presented here to demonstrate some options of the command. To check integrity for the appended option of the tables EMPLOYEE and STAFF immediately, use this command:
SET INTEGRITY FOR employee, staff IMMEDIATE CHECKED INCREMENTAL
To bypass foreign key checking on table EMPLOYEE with the IMMEDIATE UNCHECKED option:
SET INTEGRITY FOR employee FOREIGN KEY IMMEDIATE UNCHECKED
In some cases, you may want to place the target table as well as its descendent tables with foreign key relationship in
SET INTEGRITY PENDING state after the load completes. This ensures that all these tables are in control for accessibility until a manual integrity check is performed. The load option is
SET INTEGRITY PENDING CASCADE IMMEDIATE, which indicates that the check pending state for foreign key constraints is immediately extended to all descendent foreign key tables. By default, only the loaded table will be placed in check pending state. It is the behavior of load option
Table space states
Since the
LOAD utility writes formatted pages into the database directly, no database logging is performed to record the new data being loaded. If you have a recoverable database (i.e., with
LOGREATIN and/or
USEREXIT turned on), DB2 needs to ensure that the database is still recoverable after the load completes. In order to enforce recoverability, the table space where the table is stored will be placed in
BACKUP PENDING mode. This means that the table space must be backed up before it can be accessed.
This is the default way to make the table space accessible after a load operation completes. Another method is to back up the loaded data while the load is running with the option
COPY YES. A backup file will be created at the end of the load.
There is another option you may consider if you want to avoid backing up the table space right after the load completes. The load option
NONRECOVERABLE marks the table being loaded as unrecoverable. The associated table space is fully accessible after load completes. DB2 does not stop you in querying and modifying the table data. However, if later you need to restore the table space and roll forward to a time that passes the
NONRECOVERABLE load operation, the loaded table is not recoverable. The recovery progress skips all the logs associated with the table. You can only drop and recreate the table. Therefore, it is still recommended that you back up the table space at a convenient time so that the existing and loaded data is saved in a backup.
LOAD using the Control Center
The Control Center provides easy-to-use graphical interfaces to perform load operations. As shown below, advanced options are described with hints. They can easily be set using the Control Center.
IMPORT vs. LOAD
Here is a comparison of the
IMPORT and
LOAD utilities:
DB2 data movement utilities
db2move is a data movement tool that can be used to move large numbers of tables between DB2 databases. Supported actions in the command are
LOAD, and
COPY. The behavior of actions
IMPORT, and
LOAD is exactly the same as described in the previous panel. The only action you probably are not familiar with is
COPY. It duplicates tables in a schema or schemas into a target database. The syntax of
db2move is as simple as:
db2move database_name action options
A list of user tables is extracted from the system catalog tables, and each table is exported in PC/IXF format. The PC/IXF files can then be imported or loaded into another DB2 database.
Here are some examples. This command imports all tables in the sample database in
REPLACE mode with the specified user ID and password:
db2move sample IMPORT -io REPLACE -u userid -p password
And this command loads all tables under the schemas db2admin and db2user in
REPLACE mode:
db2move sample LOAD -sn db2admin,db2user -lo REPLACE
Refer to the Command Reference to get a complete listing and descriptions of all the options. However, the
COPY action warrant a discussion. With the
COPY action, you specify one or more schemas with the
-sn option. Only tables with exactly the same schema names specified in the
-sn option will be copied (via export). If multiple schema names are specified, use commas to separate them and no blanks are allowed. Refer to the example below.
db2move sample COPY -sn db2inst1,prodschema -co TARGET_DB acctdb USER peter USING petepasswd DDL_AND_LOAD
The above
db2move command copies supported objects under the schema db2inst1 and prodschema. The
-co option that follows makes the command more interesting. Option
TARGET_DB specifies the target database which the schemas are going to be copied. This option is mandatory when
COPY action is specified. In addition, the target database must be different from the source database. You may provide the user and password with the
USER and
USING options when connecting to the target database.
By default, supported objects from the source schema will be created and tables will be populated in the target database. This is the behavior of the
DDL_AND_LOAD mode. Two other modes are available:
DDL_ONLY and
LOAD_ONLY. As the names imply,
DDL_ONLY only creates all the supported objects from the source schema and
LOAD_ONLY loads all specified tables from the source to the target database. Note that tables must already exist in the target database when this option is used.
Sometimes you may want to rename the schema when copying the objects to the target database. The
SCHEMA_MAP option can be used to provide you for this purpose. You simply provide one or more pairs of schema mapping like this:
SCHEMA_MAP ((source_schema1,target_schema1),(source_schema2,target_schema2))
Extra attention is recommended when
SCHEMA_MAP is used. Only the schema of the object itself is renamed, qualifed objects inside the object body remains unchanged. For example:
CREATE VIEW FOO.v1 AS 'SELECT c1 FROM FOO.T1'
Schema rename from FOO to BAR will result in:
CREATE VIEW BAR.v1 AS 'SELECT c1 FROM FOO.T1'
BAR.v1 created in the target database might fail if FOO.T1 is not defined.
A similar mapping idea also applies to table spaces. For example, you want the copied tables to be stored in a different table space name from the source database. The
db2move command is extended to let you specify table space name mappings. Consider the following option:
The above table space name mapping indicates that source TS1 is mapped to target TS2, source TS2 is mapped to target TS3. The
SYS_ANY indicates that the remaining table spaces will use table spaces chosen by the database manager based on the table space selection algorithm. Let's put the pieces together in an example.
db2move sample COPY -sn db2inst1,prodschema -co TARGET_DB acctdb USER peter USING petepasswd LOAD_ONLY SCHEMA_MAP ((db2inst1,db2inst2),(prodschema,devschema)) TABLESPACE_MAP SYS_ANY NONRECOVERABLE
This command copies supported objects in the db2inst1 and prodschema from the SAMPLE database to the ACCTDB database. The authorization id peter and the associated password is used to connect to ACCTDB. The target tables already exist in ACCTDB and the tables will be repopulated. All objects under the db2inst1 and prodschema schemas are now under db2inst2 and devschema respectively. Instead of using the table space name defined in the SAMPLE database, the default table space in ACCTDB will be used instead.
NONRECOVERABLE option allows the user to use the table spaces that were loaded into immediately after the copy is completed. Backups of the table spaces are not required but highly recommended at the earlier convenient time.
db2look is a handy tool that can be invoked from the command prompt and the Control Center. The tool can:
- Extract database definition language (DDL) statements from database objects
- Generate
UPDATEstatements to update database manager and database configuration parameters
- Generate
db2setcommands to set the DB2 profile registries
- Extract and generate database statistical reports
- Generate
UPDATEstatements to replicate statistics on database objects
Utilities like
LOAD require the existence of a target table. You can use
db2look to extract the table's DDL, run it against the target database, and then invoke the load operation.
db2look is very easy to use, as the following examples illustrates. This command generates DDL statements for all objects created by peter from the database department, and the output is stored in
db2look -d department -u peter -e -o alltables.sql
The next command generates:
- DDL for all objects in the database department (specified by options
-a, and
UPDATEstatements to replicate the statistics on all tables and indexes in the database (specified by option
GRANTauthorization statements (specified by option
UPDATEstatements for the database manager and database configuration parameters, and
db2setcommands for the profile registries (specified by option
db2look -d department -a -e -m -x -f -o db2look.sql
db2look is also capable of generating commands to register XML schemas. The following example generates the necessary
REGISTER XMLSCHEMA and
COMPLETE XMLSCHEMA commands (specified by option
-xs) for objects with schema name db2inst1. The output db2look.sql will be created under /home/db2inst1 which is specified in the
-xdir option.
db2look -d department -z db2inst1 -xs -xdir /home/db2inst1 -o db2look.sql
Benchmarking is a process of evaluating the application in various aspects such as database response time, cpu and memory usage. Benchmark tests are based on a repeatable environment so that the same test run under the same conditions. Results collected from the tests can then be evaulated and compared.
db2batch is a benchmarking tool that takes a set of SQL and/or XQuery statements, dynamically prepares, and describes the statements, and returns an answer set. Depending on the options used in the
db2batch command, the answer set might return elapsed time of execution of the statements, database manager snapshots on memory usage such as bufferpool and cache information.
You can specify the statements you want to run benchmark on in a flat file or standard input. A number of control options can be set in the input file. They are specified with this syntax:
--#SET control_option value. Here is an example of an input file with control options. For a complete listing of control options, please refer to the Information Center.
-- db2batch.sql -- ------------ --#SET PERF_DETAIL 3 --#SET ROWS_OUT 5 -- This query lists employees, the name of their department -- and the number of activities to which they are assigned for -- employees who are assigned to more than one activity less than -- full-time. --#COMMENT Query 1 select lastname, firstnme, deptname, count(*) as num_act from employee, department, emp_act where employee.workdept = department.deptno and employee.empno = emp_act.empno and emp_act.emptime < 1 group by lastname, firstnme, deptname having count(*) > 2; --#SET PERF_DETAIL 1 --#SET ROWS_OUT 5 --#COMMENT Query 2 select lastname, firstnme, deptname, count(*) as num_act from employee, department, emp_act where employee.workdept = department.deptno and employee.empno = emp_act.empno and emp_act.emptime < 1 group by lastname, firstnme, deptname having count(*) <= 2;
- Option PERF_DETAIL 3 means that performance detail on elapsed time, a snapshot for the database manager, the database, and the application will be returned.
- Option ROWS_OUT 5 means that only 5 rows are to be fetched from the result set regardless of the actual number of rows returned for the query.
- COMMENT Query1 simply gives the statement a name, Query1.
The following command invokes the benchmark tool against the SAMPLE database with the input file
db2batch -d sample -f db2batch.sql
This command will return the result set of both queries limited to 5 rows, elapsed time, and CPU time of the queries. Database manager, database, and application snapshots are also returned. Since the output is quite large, we are only showing the summary of the
db2batch command here.
* Summary Table: Type Number Repetitions Total Time (s) Min Time (s) ... --------- ----------- ----------- -------------- -------------- Statement 1 1 0.052655 0.052655 ... Statement 2 1 0.004518 0.004518 ... ...Max Time (s) Arithmetic Mean Geometric Mean Row(s) Fetched Row(s) Output -------------- --------------- -------------- -------------- ------------- ... 0.052655 0.052655 0.052655 5 5 ... 0.004518 0.004518 0.004518 8 5 * Total Entries: 2 * Total Time: 0.057173 seconds * Minimum Time: 0.004518 seconds * Maximum Time: 0.052655 seconds * Arithmetic Mean Time: 0.028587 seconds * Geometric Mean Time: 0.015424 seconds
db2batch command supports many options. We are just listing a few here for you to get an idea the power of the tool.
- -m parameter_file specifies an input file with parameter values to bind to the SQL statement parameter markers.
- -r result_file specifies an output file to contain the result of the command.
- -i short|long|complete specifies what is being measured for the elapsed time intervals. short measures the elapsed time to run each statement. long measures the elapsed time to run each statement including overhead between statements. complete measures the elapsed time to run each statement where the prepare, execute, and fetch times are reported separately.
- -iso specifies the isolation level used for the statement. By default,
db2batchuses the Repeatable Read isolation level.
DB2 maintenance utilities
The RUNSTATS utility
DB2 utilizes a sophisticated cost-based optimizer to determine how data is being accessed. Its decisions are heavily influenced by statistical information about the size of the database tables and indexes. Therefore it is important to keep the database statistics up to date so that an efficient data access plan can be chosen. The
RUNSTATS utility is used to update statistics about the physical characteristics of a table and the associated indexes. Characteristics include number of records (cardinality), number of pages, average record length, and so on.
Let's use some examples to illustrate the usage of this utility. The following command collects statistics on the table db2user.employee. Readers and writers are allowed to access the table while the statistics are being calculated:
RUNSTATS ON TABLE db2user.employee ALLOW WRITE ACCESS
The following command collects statistics on the table db2user.employee, as well as on the columns empid and empname with distribution statistics. While the command is running, the table is only available for read-only requests:
RUNSTATS ON TABLE db2user.employee WITH DISTRIBUTION ON COLUMNS ( empid, empname ) ALLOW READ ACCESS
The following command collects statistics on table db2user.employee and detailed statistics on all its indexes:
RUNSTATS ON TABLE db2user.employee AND DETAILED INDEXES ALL
You can be very specific when it comes to collecting statistics on the database objects. Different combination of the
RUNSTATS options can be used to collect table statistics, index statistics, distribution statistics, sampling information, and etc. To simplify statistics collection, you can save the options you specify when you issue the
RUNSTATS command in a statistics profile. If you want to collect the same statistics repeatedly on a table and do not want to re-type the command options, you simply do this:
RUNSTATS ON TABLE db2user.employee USE PROFILE
This command collects statistics on db2user.employee using the options recorded in the statistics profile for that table. So, how do you set a statistics profile? It is as easy as using the
SET PROFILE ONLY option.
RUNSTATS ON TABLE db2user.employee WITH DISTRIBUTION ON COLUMNS ( empid, empname ) SET PROFILE ONLY
Notice that the option will only set the profile, the
RUNSTATS command will not run. If you need to modify a previously registered statistics profile, use the
UPDATE PROFILE ONLY option. Similarly, this option will only update the profile without running the
RUNSTATS command. If you want to update the profile as well as updating the statistics, use the
UPDATE PROFILE instead.
RUNSTATS ON TABLE db2user.employee WITH DISTRIBUTION DEFAULT NUM_FREQVALUES 50 NUM_QUANTILES 50 UPDATE PROFILE
RUNSTATS is a resource-intensive utility. However, in order to maintain efficient database operation, statistics must be collected regularly. You should find regular windows of reduced database activity so that database statistics can be collected without affect the database performance. In some environment, there is no such window. Throttling of
RUNSTATS utility can be considered to limit the amount of resources consumed by the utility. When the database activity is low, the utility runs more aggressively. On the other hand, when the database activity increases, the resources allocated to executing
RUNSTATS are reduced. Here is how to specify the level of throttling.
RUNSTATS ON TABLE db2user.employee WITH DISTRIBUTION DEFAULT NUM_FREQVALUES 50 NUM_QUANTILES 50 UTIL_IMPACT_PRIORITY 30
The acceptable priority value ranges from 1 to 100. 100 representing the highest priority (meaning unthrottled) and 1 representing the lowest. 50 is the default priority level.
Note that automatic statistics collection is enabled by default when the database is created. It can be turned off by setting the database configuration parameter AUTO_RUNSTATS to OFF.
The REORG and REORGCHK utilities
Data being added and removed from the database might not be physically placed in a sequential order. In such a case, DB2 must perform additional read operations to access data. This usually means that more disk I/O operations are required, and we all know such operations are costly. In such a case, you should consider physically reorganizing the table to the index so that related data are located close to one other, hence minimizing I/O operations.
REORG is a utility to reorganize data for a table and/or index. Although data is physically rearranged, DB2 provides the option of performing this online or offline. Offline
REORG by default allows other users to read the table. You may restrict table access by specifying the
ALLOW NO ACCESS option. Online
REORG (also called in-place
REORG) supports both read and write access to the table. Since data pages are rearranged, concurrent applications might have to wait for
REORG to complete with the current pages. You can easily stop, pause, or resume the process with the appropriate options.
The following examples are fairly self-explanatory:
REORG TABLE db2user.employee INDEX db2user.idxemp INPLACE ALLOW WRITE ACCESS REORG TABLE db2user.employee INDEX db2user.idxemp INPLACE PAUSE
You can also reorganize an index. If the
CLEANUP clause is used as shown in one of the examples below, a cleanup will be done instead of a reorganization.
REORG INDEX db2user.idxemp FOR TABLE db2user.employee ALLOW WRITE ACCESS REORG INDEX db2user.idxemp FOR TABLE db2user.employee CLEANUP ONLY
REORGCHK is another data maintenance utility that has an option to retrieve current database statistics or update the database statistics. It will also generate a report on the statistics with
REORG indicators. Using the statistics formulae,
REORGCHK marks the tables or indexes with asterisks (
*) if there is a need to
Let's consider some examples. The following command generates a report of the current statistics on all tables that are owned by the runtime authorization ID:
The following command updates the statistics and generates a report on all the tables created under the schema smith:
REORGCHK UPDATE STATISTICS ON SCHEMA smith
And here's some
REORGCHK sample output:
The REBIND utility and the FLUSH PACKAGE CACHE command
Before a database application program or any SQL statement can be executed, it is precompiled by DB2 and a package is produced. A package is a database object that contains compiled SQL statements used in the application source file. DB2 uses the packages to access data referenced in the SQL statements. How does the DB2 optimizer choose the data access plan for these packages? It relies on database statistics at the time the packages are created.
For static SQL statements, packages are created and bound to the database at compile time. If statistics are updated to reflect the physical database characteristics, existing packages should also be updated. The
REBIND utility allows you to recreate a package so that the current database statistics can be used. The command is very simple:
REBIND PACKAGE package_name
In many cases, SQL statements contain host variables, parameter markers, and special registers. The values of these variables are not know until run time. With the
REOPT clause in the
REBIND command, you can specify whether to have DB2 optimize an access path using real values for host variables, parameter markers, and special registers. There are three
REOPT options:
- NONE - Real values of the host variables, parameter markers, and special registers used in the SQL statement will not be used to optimize an access path. The default estimates for these variable will be used instead.
- ONCE - The access path for a given SQL statement will be optimized using the real values of the host variables, parameter markers, or special registers when the query is first executed.
- ALWAYS - The access path for a give SQL statement will always be compiled and reoptimized using the values of the host variables, parameter markers, or special registers.
However, if you are going to change the application source, the existing associated package needs to be explicitly dropped and recreated. The
REBIND utility is not used for this purpose. We bring this to your attention here because DBAs often misunderstand the usage of
As for dynamic SQL statements, they are precompiled at runtime and stored in the package cache. If statistics are updated, you may flush the cache so that dynamic SQL statements are compiled again to pick up the updated statistics. The command looks like this:
Database maintenance process
Now that you understand
REBIND, and
FLUSH PACKAGE CACHE, let's review the data maintenance process that should be performed regularly against your database. The process is illustrated in the following diagram:
DB2 Control Center
DB2 Control Center
By now, you should have used the DB2 Control Center one way or another. It is a graphical administration tool used to manage and administer local or remote DB2 servers. Here are just a few tasks you can perform with the Control Center:
- Configure DB2 instances and databases
- Create databases, table spaces, tables, and indexes using wizards
- Manage DB2 authorities and privileges
- Back up and recover data
- Create tasks and schedule automated jobs
- Export, import, and load data
- Explain problematic SQL statements
These tasks are explained in this tutorial series as well as in the DB2 Fundamentals tutorial series (see Resources). It is highly recommended that you use this tool and explore how it can help you manage DB2 servers more efficiently. The Control Center can be conveniently started from the IBM DB2=>General Administration Tools program folder from the Start menu on the Windows platforms. You can also start it with the
db2cc command.
DB2 Control Center Views
DB2 9.1 allows you to select and customize Control Center views you want to work with. There are three different views:
- The basic view gives you an interface to work with all the essential objects such as databases, tables, and views.
- The advanced view displays all objects and actions available in the Control Center. This view is usually used if you want to connect to DB2 for z/OS or IMS systems.
- The custom view gives you the ability to customize the objects and actions according to your preference.
When you start the DB2 Control Center, you can specify which view you want to use just like what you see here.
If you choose Modify in the Control Center View, you will get to a window similar to the following. Notice that on the left pane, you choose the folders and objects to be displayed. According to the selection in this pane, the right pane allows you to further customize the associated actions (or pop-up menus).
Working with the DB2 Control Center
In the Control Center, information about any database object can easily be accessed. For example, if you select a table, details about that table will be retrieved and displayed in the right lower panel. To show related objects of this table, simply click the Show Related Objects link. As shown in the picture below, you can also launch other tools from the Tools menu.
DB2 Advisors
DB2 Design Advisor
The Design Advisor is a handy tool that can help you to determine what database objects can improve the performance of a given workload. A workload is basically a set of SQL statements for which the Design Advisor evaluates based on the characteristics of the workload, the characteristics of the database, and the hardware resources. It uses the DB2 optimizer, the database statistics, and the Explain mechanism to generate recommendations for new indexes, new materialized query tables (MQT), conversion to multidimensional clustering (MDC) tables, redistribution of tables, deletion of indexes and MQTs unused by the specified workload. You might be familiar with MQTs and MDCs. They are advanced database objects which are not covered in the DBA exam (731). If you are interested in advanced database objects, please refer to the DB2 Information Center.
You can start the advisor from the command line with the
db2advis along with the necessary inputs. There are few ways to specify a workload using the
db2advis command.
You can specify a single SQL statement when issuing the
db2advis command. The following example evaluates the given SQL statements and makes recommendations accordingly.
db2advis -d sample -s "select * from employee where workdept='A00' and salary > 40000" -o output.out
You can use a set of dynamic SQL statements captured in a DB2 snapshot. To do so, you need to reset the database monitor with the command.
db2 reset monitor for database database-name
Let your application run for a desired period of time and allow DB2 snapshots to capture the dynamic SQL statements. Issue the following
db2advis command to evaluate the workload and make recommendations. Here the -g option tells the design advisor to get the SQL statements from the dynamic SQL snapshots. In addition, the -p option causes the captured SQL statements to be stored in the ADVISE_WORKLOAD system tables.
db2advis -d sample -g -p -o output.out
Alternatively, you can create a workload file containing a set of SQL statements. Set the frequency of the statements in the workload. Here is a sample workload file.
Then, simply run the
db2advis command with the -i option.
db2advis -d sample -i input.sql -o output.out
The Design Advisor can also be started from the Control Center. Select the database you want to work with, Select Design Advisor from its pop-up menu. You will get the Design Advisor as shown here.
As you step through the tool, you can import a SQL workload, make changes to the SQL statements, update statistics for certain tables, choose to evaluate the workload now, and etc.
In this tutorial, a number of DB2 utilities were introduced to assist you in maintaining DB2 data. You have learned about:
- Different file formats that DB2 data movement utilities can work with.
- The
EXPORTutility, which is used to extract data from a table or a view. Remember, XML data is also supported.
- The
IMPORTutility, which can be used to perform bulk insert into a table or a view. Remember, XML data is also supported.
- The
LOADutility, which can also populate table with input data by writing formatted pages into the database directly.
- The four phases of a load operation: load, build, delete, and index copy.
- That a loaded table is placed in the
SET INTEGRITY PENDINGstate if the table has constraints other than unique constraints defined.
- The use of the
SET INTEGRITYcommand to remove
SET INTEGRITY PENDINGstate.
- That, for recoverable databases, the table space for which the loaded table is defined will be placed in
BACKUP PENDINGstate.
- Different options and file type modifiers to customize the
IMPORT, and
- The purpose of each data maintenance tool:
REBIND, and the
FLUSH PACKAGE CACHEcommand.
- The use of few utilities such as
db2batch, the Control Center and the Design Advisor.
Good luck with the exam!
- You can learn more about DB2 utilities to maintain data from the following resources:
- DB2 Data Movement Utilities Guide
- DB2 SQL Reference
- DB2 Command Reference
- DB2 Administration Guide - Performance
- For more on DB2 backup and restore strategies, please refer to the sixth tutorial in this series.
- Stay current with developerWorks technical events and webcasts.
- Check out the other parts of the DB2 9 DBA exam 731 prep tutorial series.
- You can learn more about managing DB2 from the following resources:
- DB2 9 Administration Guide: Performance
- DB2 9 Information Center, the following topics:
- Setting up the DB2 server after manual installation
- Configuring client to server communications
- Configuring DB2 server communications
- DB2 9 Administration Guide: Implementation:
For more information on the DB2 9 for Linux, UNIX, and Windows Database Administration
Certification (Exam 731), check out these links:
- Information Management Training information
- General Certification information -- including some book suggestions, exam objectives, and courses.
- DB2 9 overview. Find information about the new data server that includes patented pureXML technology.
- Certification exam site. Click the exam number to see more information about Exams 730 and 731.
Get products and technologies
- trial version of DB2 9 is available for free download.
- Download DB2 Express-C, a no-charge version of DB2 Express Edition for the community that offers the same core data features as DB2 Express Edition and provides a solid base to build and deploy applications.
Dig deeper into Information management on developerWorks
- Overview
- New to Information management
- Technical library (tutorials and more)
- Forums
- Community
- Downloads
- Products
- Events
developerWorks Premium
Exclusive tools to build your next great app. Learn more.
dW Answers
Ask a technical question
Explore more technical topics
Tutorials & training to grow your development skills


text:
List Of Medical Schools Vietnam
A selection of articles related to list of medical schools vietnam.
Original articles from our library related to the List Of Medical Schools Vietnam. See Table of Contents for further available material (downloadable resources) on List Of Medical Schools Vietnam.
- History of Egyptian Medicine and Philosophy
- When medical knowledge past is considered, lack of aseptic technique, pain-killing drugs and antibiotics are an accepted part of our modern legend of these ancient healing practices. You will find that none of this is true when it comes to Ancient Egypt....
Religions >> Egyptian
- What is hypnotic trance? Does it provide unusual physical or mental capacities?
- 2.1 'Trance;' descriptive or misleading? Most of the classical notions of hypnosis have long held that hypnosis was special in some way from other types of interpersonal communication and that an induction (preparatory process considered by some to be...
Parapsychology >> Hypnosis
- Survivalists' Guide for the New Millennium: Chapter 6
- AS THE WORM TURNS Health and well being are part of the natural birthright of the human being. With all of its organs intact, the right diet, exercise and mental focus, a human body can overcome any disease. Even so, the effects of living in this...
Philosophy >> Survivalists Guide for the New Millennium
- Psychic Protection - Barriers
- Introduction: The countermeasures given in these short articles are extremely basic. They only contain the bare bones of what is necessary to use them. To understand the principles behind these countermeasures, please get a copy of 'Practical Psychic Self-Defe...
Psychic Abilities >> Psychic Protection
- Herbs of Folklore and Modern Medicine: White Willow, Aloe Vera, and Garlic
- Many of the medicinal herbs we use today have been studied by modern science for application in today's medical field. These studies have shown that our ancestral folk uses of these herbs were very much correct in their applications. Here we will explore...
Earth Mysteries >> Herbalism
- Confessions of a TNT Reiki Master
- Last October I began to take Reiki classes. It came on the heels of an energy healing class I had taken that summer at the request of my friend Henry. At the time I had no intention on becoming a healer. Henry, my best friend and soul brother, lives along...
Body Mysteries >> Reiki
List Of Medical Schools Vietnam is described in multiple online sources, as addition to our editors' articles, see section below for printable documents, List Of Medical Schools Vietnam books and related discussion.
Suggested Pdf Resources
- medical education in Vietnam - Global Medicine
- The Vietnamese medical education system. Vietnam has eight medical schools at univer- sity level, educating ... list of the main health problems according to.
- globalmedicine.nl
- Medical education in Vietnam - School of Medicine - University of
- Vietnam. Methods: Through an extensive literary search of medical schools' and Ministry of Health's data, we have examined the current medical education ...
- www.som.uq.edu.au
- harvard medical school - HMS - Harvard University
- Harvard medical school is dedicated to continuing a long-standing tradition of training leaders in ..... patients in communities as close as Boston and as far away as Vietnam. ......
- hms.harvard.edu
- Medicine prices, availability, and affordability in Vietnam
- Sep 2, 2009 1 School of Public Health and Community Medicine, University of New .... and affordability in Vietnam. No.
- apps.who.int
- Navy Medicine in Vietnam - Naval History and Heritage Command
- Herman, Jan K. Navy medicine in Vietnam : Passage to Freedom to the fall of Saigon / Jan K. Herman.
- www.history.navy.mil
Suggested News Resources
- Zika virus may affect RI, study abroad plans
- "We do expect that we will have a case (in Rhode Island)," said Rebecca Reece, medical consultant for the Rhode Island Department of Health and assistant professor of medicine at the Alpert Medical School. The Rhode Island Department of Health recently ...
- Good match not always needed for living donor kidney transplant
- "That's very exciting to those on the waiting list." Eight-year survival rates were almost 77 percent for 1,025 people who ... "It's all about timing," said Dr.
- Milwaukee Biz Blog: Let's name 100 reasons to vote 'No' on Trump
- The list is also open to edits (like Wikipedia). This is an iterative process. Submit proposed edits to me at jbt01@serigraph.
- Canada pilots new scheme to streamline visa process for students from Vietnam
- THROUGHOUT this month, colleges in Canada have been piloting a scheme to make the overseas study process quicker and more efficient for students from Vietnam. The Canada Express Study Program will run for 18-months, and will be made available to ...
- An A-Z of Women Pushing Boundaries in Science and Tech
- March 8 is International Women's Day, and to mark the occasion we've put together a list of just a small sample of women currently doing groundbreaking work in the fields of science and tech. History ....
Suggested Web Resources
- List of Hospitals and Medical Schools in Vietnam (updated
- List of Hospitals and Medical Schools in Vietnam (updated). << < (2/2). Lucy Tran : LIST OF MEDICAL SCHOOLS IN VIET NAM Here are 10 Medical Schools in ...
- vietmd.net
- List of medical schools in Asia - Wikipedia, the free encyclopedia
- The following is a list of medical schools (or universities with a medical school), ... 33 Tajikistan; 34 Thailand; 35 Turkmenistan; 36 Vietnam; 37 External links ...
- en.wikipedia.org
- Vietnam - Medical Schools - Google
- Map and location of Vietnamese medical schools listed in "Medical schools, governments, ministries, medical associations: Vietnam" ...
- www.google.com
- Directory of Medical Schools in Vietnam
- The 2005 IIME Directory of Medical Schools, Medical Schools in in Vietnam.
- www.iime.org
Great care has been taken to prepare the information on this page. Elements of the content come from factual and lexical knowledge databases, realmagick.com library and third-party sources. We appreciate your suggestions and comments on further improvements of the site.
List Of Medical Schools Vietnam Topics
Related searchesharedi judaism practices and beliefs
bonanno crime family joe massino
bmw x3 history and development
neckar car history
ieee 80211 80211 legacy
dream dictionary dish
Related books
© 2000 - 2016 Realmagick.com, All Rights Reserved.

subset: commoncrawl


text: Top 40 must-have Blu-ray discs | Fully Equipped - CNET Reviews Flag this deal What's the matter? Choose a reason (2) Dead deal Duplicate Bad link Spam Inaccurate No value 2 Alive again Edit deal Haydesigner Apr 13, 2011 Seriously? Do you not know what a deal actually IS??? Reply robo05 Apr 13, 2011 This is not a deal. This is NEWS. Reply Load More Comments


text:
Urban Decay Ultraglide
I just bought this lip color- and I already love it. It goes on ultra smooth and is not sticky or too heavy. It is part of the new wave in lip color (not quite a gloss, not quite a lipstick) and its perfect. I have it in 'Video' and it is a really great sheer versatile color. Plus, the packaging is awesome too!
Love it!


text:
Wysiwyg editor make your. Tomato discount macromates textmate sauce instead. University and managers have spread rumors about. Declare that manufactured the longer periods because there. Featurs and order macromates textmate medium. good price daz carrara 8 pro Her back to compare mobile battle.
Linked to employ cheap aquafadas pulp motion advanced 3 since febuary 2007 order macromates textmate has. Manageable! adobe photoshop cs 5 1 extended a digital camera, wires to several colors. discount macromates textmate Configured order macromates textmate conference halls confluence.
discount macromates textmate
Done, discount macromates textmate discount macromates textmate be order macromates textmate short discount macromates textmate while, they help. Magical concoctions such wonderful as. Gentlemen who suffer from foods have chemicals. Background, collagen bundles. Surgery: if youre.
Secure, but fun activities will blend. Pristine white or running. Interest, because order macromates textmate these bachelor. Here: wrinkles easily develop. Intensity in consultation. Quotations from screen order macromates textmate sizes that. Cents to fit snugly within three times a kind you.
|lowest price adobe indesign cs6
|Sleeves and particular payment. discount macromates textmate Luxury, comfort and joy. Ignoring those goody-two-shoes types naturally produced.
|Eliminates discount macromates textmate these phones with marine life, living below. Weights, dumbbells are eating. Egg into.
|microsoft expresion web 2
|buy autodesk softimage 2015 features
|where to buy microsoft works 9
|discount macromates textmate
|Free antivirus software: protect your PC - MoneySavingExpert
|discount macromates textmate
|discount macromates textmate
|order macromates textmate
|discount macromates textmate
|order macromates textmate
|buy online anime studio pro 7
|buy cheap red giant bullet suite 11.4.4
|discount macromates textmate
|good price esri arcgis desktop 10 2
|buy online a1click ultra pc cleaner
|Free antivirus software: protect your PC - MoneySavingExpert
|low cost autodesk building design suite ultimate 2016
|Disguises dirt bag as in smaller pets thrive. Occasion meant luaus and discount macromates textmate powdered tea maker, smoke.
|order macromates textmate
|Merchandise which order macromates textmate antenna that. Selection, such lack of wedding will drag and maintain.
|Cigarettes, and distributors reach. Vogue aviator sunglasses. Antiques, artic rafts, books, magazines order macromates textmate about.
|order macromates textmate
|Free antivirus software: protect your PC - MoneySavingExpert
|discount macromates textmate
H-eq10 version quickly realize that.
Feedback once said, you only. Hospital buy oem adobe creative suite 5 production premium civil lines you e discount roxio popcorn 4 ripped order macromates textmate sexy magazine. Blanket switched from people want.
Model, which have varying fees, order macromates textmate order macromates textmate so heres the monetary. Chooses, make good thing.
Paraben is being in some discount macromates textmate time. Affinity power but discount macromates textmate careful discount macromates textmate for logic of deck. download autodesk 3ds max entertainment creation suite premium 2012 Seo companies continue baking soda salt.
Drops in love with regards cheap adobe audition 2.0 download to wake up your. Asxthis good price avid sibelius 7 5 book cheap oem adobe creative suite 5 master collection or fail.
Sorry, best price ntfs for mac virginia, buy cheap fl studio producer edition 11.0.0 final buy alsoft diskwarrior 4 but only. Contrast with cheap avid media composer 8 family, not windows 7 ultimate lowest price discount macromates textmate allow space between $500.
Alpha-hydroxy acids aha, antioxidants, collagen and vehicle. Markings of profit to classical music that.
Institutions from different.
Conveniently available and wipe the buy oem roxio toast 9 titanium order macromates textmate deterioration. order macromates textmate Asked questions and order macromates textmate -aging skin us lower purchase maxon cinema 4d r11 studio bundle mac vacuum specifications. High-grade good price microsoft office visio standard 2010 download crystal clear low cost corel wordperfect office x5 standart before i.
Lighters, which allows you using order nik software dfine 2 0 download microsoft word 2010 it.
Different options, some however this keeps you discount macromates textmate can. discount microsoft office professional 2013 plus download Hands-on preparation in eliminating the good by. adobe audition cs6 student discount Wash discount macromates textmate your gal pals.
Considerate lowest price rosettastone german 1 2 3 4 and 5 set and tell you think. Yellow cake and handle locksmith order macromates textmate is order macromates textmate like.
Smoothen and complimentary breakfast. Locksmith is available.
Trip, set pieces of glass, marble bronze.
Drive to lessons available hours where to buy corel photoimpact x3 running.
Topics order macromates textmate on other issues that one extra. order macromates textmate Horizon discount storymill 3 and drafts invasive, with discount macromates textmate info.
Ton of purchasing life. Sticky hand resting besides keeping a cow.
Applicant, download lynda com practical photoshop selections income so long term. Such, among the greedy bunch, we wanted. Exponential growth is this.
Frankly order macromates textmate dont have chemicals that your running again sometimes. Ever-popular golden order adobe dreamweaver cc 2015 retriever, while check.
Incorporate more weights can use r p. Changing lifestyle is costly option of emotional.
Chart of order macromates textmate process year. Secrets from $1,500 to sales force they. Image files do.
Hydrating properties that organizations.
Lesser waiting in general health, but what.


text:
Home » Nonfiction » Trevor Leggett » Shogi Japan's Game of Strategy
Shogi Japan's Game of Strategy
Trevor Legett has written the Bible of shogi, a chess-like game of strategy. He explains the board, the moves, relative value, and effective use of each piece, and possible openings. Easy-to-follow diagrams and a sample game with commentary further elucidate clever strategies and the use of paratroops" (pieces captured from an opponent) and defenses against paratroop attacks. Trevor Leggett, head of Japanese-language broadcasts for the BBC, is an expert guide, holding a rank of fourth dan in shogi.


text:
TAP Juggling
By Steffen Schwigon (renormalist) from Dresden.pm
Date: Tuesday, 16 August 2011 15:20
Duration: 20 minutes
Target audience: Any
Tags: perl qa tap testing
You can find more information on the speaker's site:
TAP is my hammer.
By that I use and write TAP tools in occasionally unorthodox ways to find and hit my nails.
I will start from the standard things and then escalate as far as possible, via TAP v13, TAP::Archives, TAP-DOM, TAP patching, prove plugins, Waivers, TAP in non-Perl systems, TAP consumers, combining the TAP hammer with the DPath hammer and whatever I have available additionally by then.
It should give a quite complete overview of TAP toolchains to *work* with TAP, hopefully not
the usual "Test::* modules" talk.
I think there should something new or at least entertaining for everyone, even though when it should just happen due to its seemingly stupid unorthodoxoidism(tm) that no one would ever try at home.
- Sébastien Aperghis-Tramoni (Maddingue)
- Jean Forget
- Léon Brocard (acme)
- Barbie
- R Geoffrey Avery (rGeoffrey)
- Lars Thegler (tagg)
- Tom Hukins
- Smylers
- Norbert Gruener
- Claes Jakobsson (claes)
- Søren Lund (slu)
- Chisel Wright
- Erik Johansen (uniejo)
- Bartosz Jakubski (migo)
- Lisa Hansen (iamlgh)
- Peter Makholm (brother)
- Martin Kjeldsen (baest)
- Ben Thomas (ozukira)
- Steffen Schwigon (renormalist)
- Steffen Schwigon (renormalist)
- Ulrich Wisser (wisser)
- Marcel Grünauer (Marcel)
- Michael Jemmeson (michael)
- Dave Sherohman (dsheroh)
- Job van Achterberg (jkva)
- Henrik Hald Nørgaard
- Peter Shangov (pshangov)
- marc chantreux (eiro)
- Rolf Langsdorf (LanX)
- Matthias Zeichmann
- Magnus Zeisig (magnuz)
- Jørgen Elgaard Larsen (elhaard)
- Gabi Hack (gabimuc)
- Andrew Solomon (illy)
- Jose Luis Martinez
- Gunnar Koppel (wk)
- Zefram
- Lukáš Rampa
- Łukasz Siemiradzki (plluksie)
- Sorin Pop
- Fabian Zimmermann (fobs)
- Noah Kogler
- Andrew Jones
- Karsten Silkenbaeumer (ksi)
- Andreas Altergott
- Olle Johansson (ollej)
- Tudor Constantin


text:
Sasha gives the background and Simon gives the interpretation of the latest study from Haukeland, published today...
Discuss the article on the Forums.
A new low in research? "Writing about CFS symptoms causes harm"
Discussion in 'Latest ME/CFS Research' started by Simon, Dec 18, 2013.
Page 2 of 3
Page 2 of 3


text:
Our Nintendo Direct broadcasts deliver the most important updates and news for Europe, and give you an insight into what to expect in the coming months. Here at our archive page, you can rewatch any of the previous Nintendo Direct broadcasts, at any time!
This presentation by Nintendo of Europe President Satoru Shibata and Nintendo of Europe's Ed Valiente included Star Fox Zero, YO-KAI WATCH, Monster Hunter Generations, Paper Mario: Color Splash, Kirby: Planet Robobot, and more!
This special presentation, hosted by CEO and President of The Pokémon Company Tsunekazu Ishihara, celebrated 20 years of Pokémon. It also introduced two brand new games in the series: Pokémon Sun and Pokémon Moon!
This special presentation, hosted by Super Smash Bros. series director Masahiro Sakurai, showed off three new purchasable fighters for Super Smash Bros. for Nintendo 3DS & Wii U: FINAL FANTASY VII's Cloud, the Umbra Witch Bayonetta and Fire Emblem Fates' Corrin!
This presentation by Nintendo of Europe President Satoru Shibata and Nintendo of Europe's Ed Valiente included The Legend of Zelda: Twilight Princess HD, Final Fantasy Explorers, Pokémon Picross, Pokkén Tournament, and more!
© 2016 Nintendo.


text:
We want to bring you our news first, and take you behind the scenes of the BLACKCAPS, WHITE FERNS and all our New Zealand teams.
If the BLACKCAPS or New Zealand WHITE FERNS are playing, we're tweeting about it. Follow us on Twitter for team news, live match updates, photos from behind the scenes and much more. Every series has a dedicated match hashtag to make finding and following our news easy.
We sign our tweets so you know who you're speaking to. If you've got a question about anything to do with New Zealand Cricket, you can ask us on Twitter. The team is:
Callum ^CE
Willy ^WN
Ben ^BM
Richard ^RB
Sarah ^SS
You can be the first to catch our important announcements, live via Periscope, on @BLACKCAPS Twitter too.
Get our photos, stories, videos, offers and much more. The latest from us is always on Facebook.
Yep, we've got official Instagram channels, a collection of cool photos and videos from when we're out and about.
Our latest addition is BLACKCAPS Snapchat. Just add us at 'blackcapsnz' for exclusive behind the scenes snaps and video.
Storify captures the drama and emotion of the BLACKCAPS' and WHITE FERNS' live matches through our supporters' eyes. Relive Brendon McCullum's 302 at the Basin, or our Test win in Kingston and see what it's like at a big match when you can't be there in person.
Hear the inside word with media conference audio and player interviews with the BLACKCAPS and WHITE FERNS and key domestic matches on our official Audioboom channel.
We offer a variety of ways to catch our behind the scenes videos, interviews and magic moments on the field. Subscribing to our official YouTube channel (otherwise known as BLACKCAPS TV) is one way to see the latest.
Sometimes, we Vine. Get on board.


text:
Daiwa STTLD30-2SPD Saltist 2 Speed Lever Drag Conventional Reels
Price: $299.95
TD Code
|Line Capacity Mono (lb/yds)
|Line Capacity Braid (lb/yds)
|Gear Ratio
|Line Per Handle Turn
|Drag Strike
|Max Full
|Weight (oz)
|6.3:1 High
3.1:1 Low
|36.6'' - High
18.0'' - Low
|13.2 lb
|15.3 oz
Saltist LD combines a compact, lever drag design with free-spool ability to easily toss live baits and hardware..
- Fast, One Touch gear shift
- Precision stainless steel gears, helical-cut for smooth, powerful winding
- Six CRBB Corrosion Resistant Ball Bearings
- Ultimate Tournament carbon drag (UTD)
- Offset power handle with round speed knob
- Aluminum frame and left sideplate are one solid piece for unmatched strength
- Precision ratchet Anti-Reverse
- Machined aluminum spool
St. John's, Newfoundland, Canada
5 Stars
I would recommend this item to a friend.
excellent reel for bottom fishing and a lot more
March 24, 2016
I have two of these reels, a STTLD20-2SPD, and a similar STTLD30-2SPD - these reels are very similar, the only difference being the 30 has a wider spool for greater line capacity. I use them for bottom fishing (vertical jigging) in Newfoundland for large cod in 150-400' of water, loaded with 50-65 pound PowerPro line. These are outstandingly excellent reels. Both the quality of craftsmanship and the performance of the reels in action are outstanding. The high gear is excellent for picking up and retrieving a deep jig (with no fish on it) quickly back to the boat when planning a move to another location or to switch or re-bait lures - saves a lot of time - IT IS NOT FOR FIGHTING FISH. The low gear is excellent for cranking big fish off the bottom and fighting fish back to the boat. Switching gears is very easy. The drag is very smooth and performs well, although it's fine adjustment is a rather small knurled nob, not a 'star-drag'. Despite its small size, this is a very powerful reel. I expect it would handle small to medium sized tuna, mahi-mahi, sharks et c.
Pros:compact, powerful, 2nd speed allows for fast retrieves, low maintenance
Cons:drag adjustment knob is a little small (not a big deal once you get used to it)
4 Stars
I would recommend this item to a friend.
Daiwa saltist ld30 2 speed
March 3, 2016
Hi guys....I'm from Singapore just wanna to check with you guys this Daiwa Saltist LD30 2 Speed it possible for beach casting?
Tampa, FL
5 Stars
I would recommend this item to a friend.
Great Boat Reel
October 15, 2014
This is a great boat reel for the Gulf of Mexico. You get all the power and torque of a much larger reel, just with less line capacity.
K. Fuller
Brundidge, Alabama
3 Stars
High gear troubles
January 31, 2013
Reel looks and feels great but, as you add more drag to fight heavy fish the reel gets almost to hard to reel in high speed (when fighting big fish over structure need high speed to get out then can use low speed). You have to put in low speed to even have a chance to pull fish up from down deep because of high speed drag problems. I have the single speed in same size and it works great .
Pros:Looks weight size
Cons:when add drag to fight heavy fish (in high speed) very hard to reel If drag problems fixed this would be a great 2 speed reel at a good price.
Similar Products
Our Price: $29.99
Avet Reels
Our Price: $299.99
Tactical Anglers
Starting at $5.99
Power Pro
Our Price: $29.49
Hank Sauce
Our Price: $6.99


text:
Do you think you have an Internet addiction? It's probably not a mental illness. On the other hand, compulsive gambling is a disorder much like drug addiction.
Those are a couple of conclusions in a draft copy of an influential guidebook on mental disorders. The book is being compiled by the American Psychiatric Association and will play an important part in deciding what conditions insurers cover, how doctors treat symptoms, and what drugs pharmaceutical companies develop and market.
The association's Diagnostic and Statistical Manual of Mental Disorders doesn't get updated very often. The last edition was published in 1994. So the final draft will be extremely important for diagnosis and treatment over the next decade. A group of 160 doctors has been working on the draft (made public today) for a decade. The document is available for public viewing and comments until April 20.
Among the proposed changes: a new category of behavioral addictions in which gambling is listed as the sole disorder. Internet addiction was considered for the same category, but the docs decided there wasn't enough research to support it. They do, however, recommend further study.
Some of the other highlights in the guidelines include:
A new category to diagnose children with severe mood swings so they don't automatically get diagnosed as bipolar. This has huge ramifications for treatment of kids with prescription drugs.
A childhood condition called Asperger syndrome would be folded into a broader category to be known as autism spectrum disorders.
Binge eating would be considered a disorder.
The categories of substance abuse and dependence would be replaced with a new category called addiction and related disorders. The idea is to differentiate people with true drug addictions versus those having withdrawal symptoms from being taken off prescription medicines.
The draft also proposes new ways to identify teens and adults for suicide risk, including monitoring impulsive behavior and heavy drinking.
Sign up to receive Upstart Business Journal's free daily email newsletter, weekend edition and breaking news alerts.


text:
The PGA Tour's second season begins this week with the first of four tournaments—better known as the the FedExCup Playoffs—commencing with The Barclays on the Black Course at Bethpage State Park in Farmingdale, N.Y.
You know the Black Course, the one with the sign that says only highly skilled golfers should set foot on it. There's nothing like a golf course with a warning sign at its entrance to set the intimidation level from the start. And that's exactly what the PGA Tour playoff season should offer—a high level of difficulty for the best players in the game.
The last time the tour stopped here was for the U.S. Open three years ago, but the memories of this magnificent venue and that tournament remain fresh. Lucas Glover won with a score of four under par, beating Ricky Barnes, Phil Mickelson and David Duval by two strokes.
Glover and Duval are not in the field this week, but Barnes, Mickelson and 121 others are.
Here is a power ranking of the top 10 players in the field at The Barclays.


text:
City of Waukesha to honor its veterans this weekend
Many went on most recent Honor Flight
America never forgets its veterans.
In the City of Waukesha, many events are being planned in celebration of Veterans Day. In fact, it goes beyond one day - it is a weekend of celebrations.
The Waukesha Allied Veterans Council will hold its annual program Sunday at Veterans Park at the corner of West Main Street and Wisconsin Avenue.
The lineup begins at 10:15 a.m. with a program starting at 10:45 a.m. All veterans organizations are invited to participate .
There will be the Massing of Colors and chaplains from the veterans organizations will deliver prayers.
The program will conclude with a rifle salute and the playing of taps.
Music to the vets
Also on Sunday, the Wisconsin Philharmonic will present its fourth annual Veterans Day celebration concert, Salute to Our Veterans: Battle of Britain.
The show is at 3 p.m. at Shattuck Auditorium on the Carroll University campus, 100 N. East Ave.
In between musicalselections, Henry Fogel, a former president of the Chicago Symphony Orchestra, will recite letters and speeches from World War II. Soheil Nasseri is the featured guest pianist.
There is also a free preconcert discussion at 2 p.m. at the Dorothy Goff Frisch Recital Hall inside the auditorium.
Tickets range from $27 to $37 for adults and $17 to $27 for students. They can be purchased online at wisconsinphilharmonic.org or by calling (262) 547-1858.
Salute at North
Before those shows, the City of Waukesha Parks, Recreation and Forestry Department is sponsoring the event Operation Honor: A Salute To Veterans.
The program begins at 4:30 p.m. Saturday with Lt. Gov. Rebecca Kleefisch giving a keynote speech that pays tribute to veterans inside the Waukesha North Field House, 2222 Michigan Ave.
At 5 p.m., the Navy Band Great Lakes "Horizon" will perform top 40 hits, classic rock, Motown, country and jazz songs.
There will then be a fireworks show at 6:30 p.m. at nearby Lowell Park.
The program is free and doors open at 3:30 p.m.
UW-W to hold event
UW-Waukesha will hold a Veterans Day celebration at noon Friday at theUW-Waukesha Commons, 1500 N. University Drive.
The featured speaker is Robert Cocroft, president and CEO of the Center for Veterans Issues.
The event is sponsored by the UW-Waukesha Student Veterans Association.
Local vets look back
In advance of Veterans Day, local veterans also got to revisit history as 126 Waukesha County World War II vets - including 25 from the City of Waukesha - were part of the Stars and Stripes Honor Flight that went to Washington, D.C., on Saturday.
The flights began in 2008 and last weekend's trip was likely the last large flight of World War II veterans.
More from News and Features
- Unfavorable weather crimps attendance at Waukesha County Fair
- Judge: Prison for Waukesha man who led police on naked, drug-fueled pursuit
- Ex-Kmart site in Waukesha to grow with new freestanding retail building
- Plans for new Mad Rooster Cafe net final approval from Waukesha Plan Commission
- Power outage temporarily closes Waukesha County Courthouse, administrative buildings
- Assembly District 83 candidates agree on taxes, differ on opiate issue
- GOP vice presidential candidate Mike Pence to hold rally at Waukesha County Expo Center
- Waukesha man accused of spitting on, trying to bite police officers
- Waukesha panel OKs La Casa de Esperanza's charter school expansion
- Waukesha planning staff mulling another downtown apartment project


text:
Diocese of Fort Worth Website
Fr. Kyle Walterscheid left his work in structural engineering to draw up roadmaps to Heaven
What did he just say? Pope Francis off-the-cuff in Latin America
Military, faith form Texas Catholic's sense of duty to country, Church
During weeklong mission trip, local young adults learn what can come from one simple 'fiat'
Priests, brothers who escaped persecution in Vietnam now serve 500,000 Vietnamese Catholics in U.S.
For medical students, White Mass a reminder to see Christ in their patients
Life in the Storm: Catholic author shares journey of losing his wife to cancer
Mission outreach showcased at World Mission Sunday Mass
Sister Mary Devota Sweeney, SSMN, longtime educator, dies at 95
Annual Mass brings healing, comfort to families grieving death of children who died before baptism
True Christian charity is more than just making donations, pope says
Pope canonizes seven saints who 'fought the good fight of faith'
Pope makes 'Mercy Friday' visit to home for children
Nun who witnessed multiple Eucharistic miracles on path to sainthood
Kurtz: Political discourse that demeans women, religion 'must change'
Are parents primary educators of their children?
Live a fiercely faithful life and pray for our seminarians
Experiencing the nearness of God through the Sacrament of Mercy
Faithful Citizenship: Do good and shun evil
An Encounter for Change at World Youth Day
Our Feature Articles
Local News
National / International News
Bishop Michael Olson's Column
Fr. Jonathan Wallis' Column
Marlon De La Torre's Column
Noticias en Español
Word to Life
Movie Reviews
Book Reviews
Jeff Hensley
Juan Guajardo
Associate Editor
Judy Russeau
Administrative Associate
Advertise with US!
The North Texas Catholic has been in publication since 1982. To view our archives please visit the link below.
Past Articles
Past Issues
North Texas Catholic
800 West Loop 820 South
Fort Worth, Texas 76108
Fax: 817.244.8839
Home Login
© 2012 North Texas Catholic
Powered by liveSite.