To build and install the DBD::DB2 module, you need the following: *Perl 5.004_04 or later *DBI 0.93 or later *DB2 Application Development Client *A supported C compiler as documented under 'Supported Operating Systems' at the DB2 Application Development Web page: http://www-3.ibm.com/software/data/db2/udb/ad/index.html Install Notes: http://www.perl.com/CPAN-local/modules/by-module/DBD/DBD-DB2-0.76.readme Module: http://www.perl.com/CPAN-local/modules/by-module/DBD/DBD-DB2-0.76.tar.gz Notes: ----------------------------- SQL-Ledger tested with IBM DB2 v7.2 and v8.1. Compiled for use with DBI 1.18 for all testing. DB2 Application Development Client used was with the DB2 Personal Developer's Edition (PDE). All databases and application code tested under RedHat Linux 7.2 kernel 2.4.7-10. ADDITIONAL NOTES: DB2 specific ------------------------------ 1. DB2 installed under default owner, and group: db2inst1 and db2grp1. 2. SQL-Ledger app owner (ledger) was added to DB2 group db2grp1 thereby given SYSADM authority. 3. SQL-Ledger app owner has same ENV variables as the db2inst1 user. This can be added, or have: . $DB_HOME/sqllib/db2profile in the SQL-Ledger app owner .(bash_)profile. 4. SQL-Ledger app owner must have environment variable DB2INSTANCE set. 5. SQL-Ledger app owner, now with SYSADM authority and PATH containing DB2's bin should run the following: prompt>: db2set -all # To view instance and registry variables prompt>: db2set DB2DBDFT=your_default_database_name i.e. LEDGER prompt>: db2set DB2CLIINIPATH=set_to_usually $DB_HOME/sqllib/cfg Now, cd to the DB2CLIINIPATH directory and edit the db2cli.ini file. Continuing with our use of LEDGER as the database that will be created and used, add: [LEDGER] AUTOCOMMIT=1 LONGDATACOMPAT=1 DBALIAS=LEDGER DEFERREDPREPARE=1 If DEFERREDPREPARE=1 is the last line, add a blank line. A blank line must be the last line. 6. Create the database, objects, and initialize by moving to the directory: /where_you_installed_SQL-Ledger/sql , and review the file DB2-sql-ledger.order. The commands outlined are in the required order, create a database called LEDGER using default SMS tablespaces. The last command-line creates the "Default" Chart-of-Accounts. *Modify the files at will to: create a different named database (make sure you review the step where you -> db2set DB2DBDFT=your_default_database_name) create DMS tablespaces different Chart-of-Accounts. If a 'gifi' sql script needs to be run, make sure the "db2 -tvf" is used so the ';' are accepted as command terminators.