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