blob: 2e5230a4db8e6ab54624cf2421117907dfd4740a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
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.
|