summaryrefslogtreecommitdiff
path: root/doc/README.DB2
diff options
context:
space:
mode:
Diffstat (limited to 'doc/README.DB2')
-rwxr-xr-xdoc/README.DB282
1 files changed, 0 insertions, 82 deletions
diff --git a/doc/README.DB2 b/doc/README.DB2
index 9d143bef..e69de29b 100755
--- a/doc/README.DB2
+++ b/doc/README.DB2
@@ -1,82 +0,0 @@
-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:
------------------------------
-
-LedgerSMB 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. LedgerSMB app owner (ledger) was added to DB2 group db2grp1
- thereby given SYSADM authority.
-
-3. LedgerSMB app owner has same ENV variables as the db2inst1 user.
- This can be added, or have:
- . $DB_HOME/sqllib/db2profile in the LedgerSMB app owner .(bash_)profile.
-
-4. LedgerSMB app owner must have environment variable
- DB2INSTANCE set.
-
-5. LedgerSMB 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.