?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
?? ??? ???? ??? DB2 UDB V8.2 ? 32-bit ? 64-bit ????
?????? ??? ??? ????? ?????.

---

DB2 UDB V8.2??? 32-bit/64-bit ?????? ?? II

??? ???? Application/Routine ??
??? 32-bit instance? ???? Application? Routine? ???? ???,
?? 64-bit instance? ???? ??? ????.
?? ?? ??? ??? ????? ???? ?? ?????.
application? Routine? ?? ????? ?????, ???? ??? ??? ????
??? ???? ?? ?????. ?? ?? ISO ??? ??? ???? ????,
?? ????? ???? ??? ???? ???, ????? ???? ????
hard coding?? ??? ???? ?? ????.

Portable ??? ??
32-bit? 64-bit Application?? ?? ??? ??? bit ?? ?? ? ????.
?? ?? DB2? ???? ?? UNIX ????? long ??? 32-bit application???
32-bit? ????, 64-bit application??? 64-bit? ?????.
Windows??? long ??? ?? 32-bit ? ?????.
?? ?? C? C++?? bit ? ??? ??? ?????. - 32-bit/64-bit application?? C? C++ ??? ??? Bit ?
32-bit ?? ??? application? 64-bit application?? ?????, ??? ???
????? ??? application? ????? ??? ?? ????.
?? ?? ?? ???? ????? ??? ???? ??? ??? ?? ????.
?? ?? ?? ? ? ??? ????? ?????.
SQL ??? ??? BIGINT ? ?? ?????? ??? ?? ??? ????
????? ????????.

1. long long
2. long
3. _int64

a? ???? UNIX ?????? ??? ? ????.
b? ???? 64-bit UNIX ?????? ??? ? ????.
c? ???? Windows ?????? ??? ? ????.

??? ??? ??? ???? ???? ???? ??? ??? ??? ????
??? DB2? ???? portable ??? ??? ???? ???.
sqllib/include (UNIX) , SQLLIBinclude ? ?? sqlsystm.h ?? ?? ??? ?????.
? ??? portable ??? ??? ???? ????.
DB2 ? ???? ?? ??? ??? ????.
- DB2 ?? ??? ?? ?? ??? ??

C? C++? ????? Java?? long? ?? 64-bit??? BIG INTEGER ?? ????
integer ??? ??? ?? 32-bit??? SQL INTEGER ?? ?????.

LONGERROR YES ?? ??
C? C++ ??? long ??? ??? ? ???? ??? precompile ?? ?
LOGERROR ??? ???? ????. ? ??? ???? 32-bit application ?
precompile ?? long ??? ??? ?????? ?? ? ?? ??? ?????.
LONGERROR ??? ???? ?? application? 64-bit ? ????? ??? ? ???
??? ? ?? ?? ??? ???.
?? ??? ??? ????.
- ???? ????

- LONGERROR YES ??? ???? precompile

??? ?? 7???? long ?????? sqllint32 ? ????? ??? ? ??
? ? ????. ? long y ? sqlint32 y ? ???? precompile? ?? ???? ???.
- ?? ??
- ?? ? precompile ??

bit? ?? ???
Java? COBOL? ??? ?? ?? ????? ??? ??? ??, ? bit? ?? ???
??? ????? ???. Java? ?? 32-bit application? 64-bit instance??
??? ? ???, ? ?? TYPE 1? TYPE 2 JDBC ? ??? ? ????.
??? bit? ?? JVM ? ???? ?? ????.
COBOL ? ?? ?? 32bit application ? ?????.

cross-platform (32-bit/64-bit) ?? application ??
??? ???? ???? ???? 32-bit application? 32-bit DB2 library ?
link?????, 64-bit application? 64-bit DB2 library ? link??? ???.
bit ? library? ?? ????? ?????.
- $INSTHOME/sqllib/lib (UNIX) - $INSTHOMESQLLIBlib (windows) ????? 32-bit instance? 32-bit library? ??? ???, 64-bit instance?
64-bit library? ??? ???, cross-platform link? ???? ??? ?? bit library?
?? ??? ????.
- bit? library ??
?? ??? ??? ????.
- ??? ? ?? ???

• HP-UX : -wl, +b$DB2PATH/lib32
• Linux : -wl, -rpath, $DB2PATH/lib32
• Solaris : -R$DB2PATH/lib32
• AIX : -L$DB2PATH/lib32 (-blibpath ??? ???? ?)

Run-time library path ??
Run-time ? ??? Library path? ????? ??? ? ????.
???? library path ??? ??? ????.
- ???? ??

---

XpertMon for DB2 UDB V2
DB ???
Tel : 02-2108-1458
Fax : 02-2108-1459
Mobile : 011-896-6545
E-mail : hjlee@iteg.co.kr
URL : http://iteg.co.kr