»õ »ùÇà ÆÄÀÏ ibm_db2_sln_upart_smt´Â DB2 UDB(Universal Database(TM)) |¹öÀü 8.2 FixPak 3(V8.1 Fixpak 10°ú µ¿ÀÏ)¿¡¼ »ç¿ë °¡´ÉÇÕ´Ï´Ù. ´ÙÀ½ Å×ÀÌºí¿¡¼´Â |»ùÇà ÆÄÀÏÀÇ À̸§ ¹× ¼³¸íÀ» Ç¥½ÃÇÕ´Ï´Ù.
| | |»ùÇà ½ºÅ©¸³Æ® À̸§ | |ÆÄÀÏ ¼³¸í | |
---|---|
ibm_db2_sln_upart_smt | |AIX¿ë ÀÌ Korn ½© µ¿Àû À籸¼º ½ºÅ©¸³Æ®(DR ½ºÅ©¸³Æ®)´Â |POWER5 ±â¹Ý pSeries(R) ½Ã½ºÅÛ(¿¹: p5 570 ¹× p5 590)¿¡¼ |½ÇÇàÇÏ´Â AIX ¹öÀü 5.3¿¡¼ Á¦°øÇÏ´Â DLPAR(Dynamic Logical |Partitioning) ¼º´ÉÀ» È°¿ëÇÕ´Ï´Ù. ÀÌ ½ºÅ©¸³Æ®´Â ibm_db2_sln |DR ½ºÅ©¸³Æ®¿Í À¯»çÇÏÁö¸¸ ¸¶ÀÌÅ©·Î ÆÄƼ¼Å´× ¹× SMT¿Í °°Àº |POWER5(TM) ¹× AIX V5.3 ±â´ÉÀ» Áö¿øÇϵµ·Ï ÃÖÀûȵǾú½À´Ï´Ù. Ãß°¡ Á¤º¸´Â |DR ½ºÅ©¸³Æ®¿¡ ÀÖ½À´Ï´Ù. | |
ibm_db2_sln_upart_smt »ùÇà ½ºÅ©¸³Æ®´Â AIX¿ë DB2 UDBÀÇ
|
|sqllib/samples/DLPAR µð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù.
¼³Ä¡ ¼¼ºÎ»çÇ×Àº DB2 UDB ¹öÀü 8.2.2 ¸±¸®½º Á¤º¸ÀÇ ¡ºLinux 2.6 Ä¿³Î ¼³Ä¡ À̹ÌÁö¡»(ÀÌ ¸±¸®½ºÀÇ »õ·Î¿î ±â´É Àý)¸¦ ÂüÁ¶ÇϽʽÿÀ.
´ÙÀ½ Ç¥´Â FixPak 9ÀÇ ¸±¸®½º·Î¼ÀÇ DB2 Linux ¾ÆÅ°ÅØó Áö¿øÀ» ¼³¸íÇÕ´Ï´Ù. ´ÙÀ½ À¯È¿¼º È®ÀÎ À¥ »çÀÌÆ®¿¡¼ ÀÌ Áö¿ø¿¡ ´ëÇÑ ¾÷µ¥ÀÌÆ®¸¦ È®ÀÎÇϽʽÿÀ.
http://www.ibm.com/db2/linux/validate
ºÐ»ê | Ä¿³Î | ¶óÀ̺귯¸® | ÁÖ¼® |
---|---|---|---|
Conectiva Linux Enterprise Edition (CLEE) | 2.4.19 | glibc 2.2.5 | United Linux 1.0¿¡ ÀÇÇØ ±¸µ¿µÊ |
LINX Rocky Secure Server 2.1 | 2.4.21 | glibc 2.2.5 | |
Red Flag Advanced Server 4.0 | 2.4.21-as.2 | glibc 2.2.93-5 | |
Red Flag Function Server 4.0 | 2.4.20-8smp | glibc 2.2.93-5 | |
Red Hat Enterprise Linux 2.1 AS/ES/WS | 2.4.9-e16 | glibc 2.2.4 | |
RHEL(Red Hat Enterprise Linux) 3 AS/ES/WS | 2.4.21-7.EL | glibc-2.3.2-95.3 | |
RHEL(Red Hat Enterprise Linux) 4 | 2.6.9 | glibc-2.3.3 | compat-libstdc++-33 ÆÐÅ°Áö |
SCO Linux 4.0 | 2.4.19 | glibc 2.2.5 | United Linux 1.0¿¡ ÀÇÇØ ±¸µ¿µÊ |
SuSE Pro 8.0 | 2.4.18 | glibc 2.2.5 | |
SuSE Pro 8.1 | 2.4.19 | glibc 2.2.5 | |
SLESSuSE Linux Enterprise Server) 7 | 2.4.7 | glibc 2.2.2 | |
SLES(SuSE Linux Enterprise Server) 8 | 2.4.19 | glibc 2.2.5 | SuSE ¼ºñ½º ÆÑ 2 ·¹º§±îÁö À¯È¿ÇÔ |
SLES(SuSE Linux Enterprise Server) 9 | 2.6.5 | glibc-2.3.3 | |
Turbolinux 7 Server | 2.4.9 | glibc 2.2.4 | |
Turbolinux 8 Server | 2.4.18-5 | glibc 2.2.5 | |
Turbolinux Enterprise Server 8 | 2.4.19 | glibc 2.2.5 | |
United Linux 1.0 | 2.4.19 | glibc 2.2.5 |
ºÐ»ê | Ä¿³Î | ¶óÀ̺귯¸® | ÁÖ¼® |
---|---|---|---|
Red Hat 7.2 | 2.4.9-34 | glibc 2.2.4 | |
Red Hat 7.3 | 2.4.18 | glibc 2.2.5 | |
Red Hat 8.0 | 2.4.18-14 | glibc 2.2.93-5 | |
SuSE 7.3 | 2.4.10 | glibc 2.2.4 |
ºÐ»ê | Ä¿³Î | ¶óÀ̺귯¸® | ÁÖ¼® |
---|---|---|---|
Red Hat 7.2 | 2.4.9-38 | glibc 2.2.4 | |
RHEL(Red Hat Enterprise Linux) 4 | 2.6.9 | glibc-2.3.3 | compat-libstdc++-33 ÆÐÅ°Áö |
SLESSuSE Linux Enterprise Server) 7 | 2.4.7-58 | glibc 2.2.4 | compat.rpm¿¡´Â libstdc++ 6.1ÀÌ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. JDK 1.3.1 SR 1 for Java(TM)¸¦ »ç¿ëÇϽʽÿÀ. |
SLES(SuSE Linux Enterprise Server) 8 | 2.4.19 | glibc 2.2.5 | United Linux 1.0¿¡ ÀÇÇØ ±¸µ¿µÊ |
SLES(SuSE Linux Enterprise Server) 9 | 2.6.5 | glibc-2.3.3 | |
TLES(Turbo Linux Enterprise Server) 8 | 2.4.19 | glibc 2.2.5 | United Linux 1.0¿¡ ÀÇÇØ ±¸µ¿µÊ |
United Linux 1.0 | 2.4.19 | glibc 2.2.5 |
ºÐ»ê | Ä¿³Î | ¶óÀ̺귯¸® | ÁÖ¼® |
---|---|---|---|
RHEL(Red Hat Enterprise Linux) 3 AS/ES/WS | 2.4.21-7.EL | glibc-2.3.2-95.3 | |
RHEL(Red Hat Enterprise Linux) 4 | 2.6.9 | glibc-2.3.3 | compat-libstdc++-33 ÆÐÅ°Áö |
SLES(SuSE Linux Enterprise Server) 8.0 | 2.4.19-SMP | glibc 2.2.5-16 | |
SLES(SuSE Linux Enterprise Server) 9 | 2.6.5 | glibc-2.3.3 |
ºÐ»ê | Ä¿³Î | ¶óÀ̺귯¸® | ÁÖ¼® |
---|---|---|---|
RHEL(Red Hat Enterprise Linux) 3 AS | 2.4.21-7.EL | glibc-2.3.2-95.3 | |
RHEL(Red Hat Enterprise Linux) 4 | 2.6.9 | glibc-2.3.3 | compat-libstdc++-33 ÆÐÅ°Áö |
SLES(SuSE Enterprise Server) 8 | 2.4.19-16 | glibc 2.2.5 | United Linux 1.0¿¡ ÀÇÇØ ±¸µ¿µÊ |
SLES(SuSE Linux Enterprise Server) 9 | 2.6.5 | glibc-2.3.3 | |
Turbolinux Enterprise Server 8 | 2.4.19-16 | glibc 2.2.5 | United Linux 1.0¿¡ ÀÇÇØ ±¸µ¿µÊ |
United Linux 1.0 | 2.4.19 | glibc 2.2.5 |
ºÐ»ê | Ä¿³Î | ¶óÀ̺귯¸® | ÁÖ¼® |
---|---|---|---|
Red Hat Enterprise Linux 2.1 AS/ES/WS | 2.4.18-e.12smp | glibc | |
RHEL(Red Hat Enterprise Linux) 3 AS/ES/WS | 2.4.21-7.EL | glibc-2.3.2-95.3 | |
RHEL(Red Hat Enterprise Linux) 4 | 2.6.9 | glibc-2.3.3 | compat-libstdc++-33 ÆÐÅ°Áö |
SLES(SuSE Linux Enterprise Server) 8 | 2.4.19-SMP | glibc 2.2.5 | United Linux 1.0¿¡ ÀÇÇØ ±¸µ¿µÊ |
SLES(SuSE Linux Enterprise Server) 9 | 2.6.5 | glibc-2.3.3 | |
United Linux 1.0 | 2.4.19 | glibc 2.2.5 |
Intel x86ÀÇ Linux 2.6 Ä¿³Î ±â¹Ý Linux ¹èÆ÷ÆÇ¿ë DB2 UDB´Â ´ÙÀ½°ú °°Àº ÇÁ·Î±×·¡¹Ö ¾ð¾î¿Í ÄÄÆÄÀÏ·¯¸¦ Áö¿øÇÕ´Ï´Ù.
x86-64ÀÇ 2.6 Ä¿³Î ±â¹Ý Linux ¹èÆ÷ÆÇ¿ë DB2 UDB¿¡¼ 32ºñÆ® ÀνºÅϽº´Â ´ÙÀ½°ú °°Àº ÇÁ·Î±×·¡¹Ö ¾ð¾î¿Í ÄÄÆÄÀÏ·¯¸¦ Áö¿øÇÕ´Ï´Ù.
x86-64ÀÇ 2.6 Ä¿³Î ±â¹Ý Linux ¹èÆ÷ÆÇ¿ë DB2 UDB¿¡¼ 64ºñÆ® ÀνºÅϽº´Â ´ÙÀ½°ú °°Àº ÇÁ·Î±×·¡¹Ö ¾ð¾î¿Í ÄÄÆÄÀÏ·¯¸¦ Áö¿øÇÕ´Ï´Ù.
SQL ÇÁ·Î½ÃÀú¿¡ ´ëÇÑ ÇÁ¸®ÄÄÆÄÀÏ ¹× ¹ÙÀÎµå ¿É¼ÇÀº ´ÙÀ½À» »ç¿ëÇÏ¿© ÀνºÅϽº Àü¹ÝÀÇ DB2(R) ·¹Áö½ºÆ®¸® º¯¼ö DB2_SQLROUTINE_PREPOPTS¸¦ ¼³Á¤ÇÏ¿© »ç¿ëÀÚ Á¤ÀÇÇÒ ¼ö ÀÖ½À´Ï´Ù.
db2set DB2_SQLROUTINE_PREPOPTS=<options>
¹öÀü 8.2¿¡ Á¦½ÃµÈ ¿É¼Ç ¿Ü¿¡µµ REOPT ¿É¼ÇÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
BLOCKING {UNAMBIG | ALL | NO} DATETIME {DEF | USA | EUR | ISO | JIS | LOC} DEGREE {1 | degree-of-parallelism | ANY} DYNAMICRULES {BIND | RUN} EXPLAIN {NO | YES | ALL} EXPLSNAP {NO | YES | ALL} FEDERATED {NO | YES} INSERT {DEF | BUF} ISOLATION {CS | RR | UR | RS | NC} QUERYOPT optimization-level REOPT {ALWAYS | NONE | ONCE} VALIDATE {RUN | BIND}
ÄÄÆÄÀÏ·¯ ¿É¼Ç "-m64"´Â gcc/g++¸¦ »ç¿ëÇÏ¿© POWER ±â¹Ý Linux(TM)¿ë DB2 Universal Database(TM)ÀÇ 64ºñÆ® ÀνºÅϽº¿¡ ´ëÇÑ C/C++ ÀÀ¿ëÇÁ·Î±×·¥ ¹× ·çƾÀ» ºôµåÇÒ ¶§ ÇÊ¿äÇÕ´Ï´Ù.
ÄÄÆÄÀÏ·¯ ¿É¼Ç "-q64"´Â xlc/xlC¸¦ »ç¿ëÇÏ¿© POWER ±â¹Ý Linux¿ë DB2 Universal DatabaseÀÇ 64ºñÆ® ÀνºÅϽº¿¡ ´ëÇÑ C/C++ ÀÀ¿ëÇÁ·Î±×·¥ ¹× ·çƾÀ» ºôµåÇÒ ¶§ ÇÊ¿äÇÕ´Ï´Ù.
DB2 Universal Database ¹öÀü 8.2 ¹®¼¿¡¼ ³ª¿Í ÀÖ´Â, HP-UX¿¡¼ Micro Focus COBOLÀ» »ç¿ëÇÏ¿© ½ºÅä¾îµå ÇÁ·Î½ÃÀú¸¦ ºôµåÇϱâ À§ÇÑ ÄÄÆÄÀÏ ¹× ¸µÅ© ¸í·ÉÀº ¿Ã¹Ù¸£Áö ¾Ê½À´Ï´Ù. ½ÇÁ¦ ½ºÅ©¸³Æ® sqllib/samples/cobol_mf/bldrtn¿¡ Æ÷ÇÔµÈ ÄÄÆÄÀÏ ¸í·ÉÀÌ ¿Ã¹Ù¸¥ ¸í·ÉÀÔ´Ï´Ù. ÄÄÆÄÀÏ ¹× ¸µÅ© ¸í·ÉÀº ÀÌÁ¦ ÇϳªÀÇ ´ÜÀÏ ¸í·É¿¡ °áÇյ˴ϴÙ. -y ¿É¼ÇÀ» »ç¿ëÇÏ¿© ¿øÇÏ´Â Ãâ·ÂÀÌ °øÀ¯ ¶óÀ̺귯¸®ÀÓÀ» ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
HP-UX¿¡¼ Micro Focus COBOL ÄÄÆÄÀÏ·¯ ¹× ·±Å¸ÀÓÀÇ ÃÖ¼Ò Áö¿ø ¹öÀüÀº Micro Focus Server Express 2.2 - Service Pack 1 + Fix Pack Fixpack22.02_14 for HP-UX PA-RISC 11.x(32/64ºñÆ®)ÀÔ´Ï´Ù. ÀÌ FixPackÀº Micro Focus Support Line À¥ »çÀÌÆ®(http://supportline.microfocus.com)¸¦ ÂüÁ¶ÇϽʽÿÀ.
Windows(R)¿¡¼ Micro Focus COBOL ¿ÜºÎ ·çƾÀ» ½ÇÇàÇÏ·Á¸é Micro Focus COBOL ȯ°æ º¯¼ö°¡ ¿µ±¸ÀûÀ¸·Î ½Ã½ºÅÛ º¯¼ö·Î ¼³Á¤µÇ¾î ÀÖ´ÂÁö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù.
ȯ°æ º¯¼ö¸¦ ½Ã½ºÅÛ º¯¼ö¿¡ ¼³Á¤ÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
»ç¿ëÀÚ º¯¼ö ¸ñ·Ï¿¡¼, ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼ ¶Ç´Â ½ºÅ©¸³Æ®¿¡¼ ȯ°æ º¯¼ö¸¦ ¼³Á¤ÇÏ´Â °ÍÀ¸·Î´Â ÃæºÐÇÏÁö ¾Ê½À´Ï´Ù.