DATABASE MANAGEMENT
DB2 Application Development Reference Guide
The DB2 Application Development reference is a Guide for DB2 application developers at the State of Nebraska. These guidelines provide help for all persons involved in a development effort to know what is required at all phases of the development cycle. See DB2 Application Development Reference (PDF: 324K )for more info.

DB2 SQL Coding Rule of Thumb
The SQL Coding Rules of Thumb contain tips for efficient coding of SQL statements. Performance should be considered when coding JOINS, ORDER BY and BETWEEN statements. Standards should be used when coding SELECT statements. Style guidelines and Cobol coding tips can also be found here. See DB2 SQL Coding Rules of Thumb (PDF: 30k) for examples and more info. 

DB2 Explain
Have you ever wondered if an index is being used in your DB2 application? The DB2 Explain statement can be very helpful in determining the access path your SQL statement is taking. Plan Analyzer is a tool that can give you easy to understand reports using data returned by an Explain. See DB2 Explain (PDF: 57k) for more info on using DB2 Explain and Plan Analyzer. 

DBM Policies, Procedures, and Guidelines
The Database Management Group has developed a number of helpful documents that explain DBM Policies, Procedures, and Guidelines. See Policies, Procedures, and Guidelines to view a menu of the choices available.

DBM Staff Responsibilities
What is the function of the Database Management Group? The roles and responsibilities of DataBase staff members include creating the physical database, setting up Image Copies and reorganizing datasets to prevent inadequate space abends. See DBM Staff Responsibilities (PDF: 124k) for more detailed info! 

DB2 -805 SQL Analysis and Resolution
How do you resolve a -805 Consistancy Token Not Found in Plan error condition? This document helps you to understand how DB2 programs are prepared, bound, executed and how to obtain error information that will help you resolve the -805. See DB2 -805 SQL Analysis and Resolution (PDF: 58k) for more info.

Frequently Asked Questions: DB2 & IMS
Why do we code COMMITS? How do I communicate with DB2? What is a deadlock? What is DRDA? What is the purpose of a secondary index in IMS? See Frequently Asked Questions for the answers to these and other common DB2 and IMS questions! 

Links of Interest
Connect to the Great Plains DB2 Forum, the IDUG Home Page, and the IBM/DB2 Home Page . See Links of Interest for these links or click on above.