import sql-ledger 2.4.4

[freeside.git] / sql-ledger / sql-ledger / doc / README.DB2

diff --git a/sql-ledger/sql-ledger/doc/README.DB2 b/sql-ledger/sql-ledger/doc/README.DB2
new file mode 100644 (file)
index 0000000..2e5230a
--- /dev/null
+++ b/sql-ledger/sql-ledger/doc/README.DB2
@@ -0,0 +1,82 @@
+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.