ebook 185-6

6 Red Hat Linux DB2 Universal Database 6.1 D B 2 Red Hat D B 2 Control Center D B 2 D B 2 D B 2 6.1 DB2 Universal Database [DB2]6.1 D B 2 O LT P O L A P D B 2 I B M P C We e k D B 2 D B 2 L i n u x Windows NT Wi n d o w s 9 x O S / 2 A I X P T X H P - U X S u n S o l a r i s D B 2 J a v a J D B C J D B C J a v a J a v a D B 2 J D B C J a v a We b We Netscape Navigator D B 2 J D B C J a v a D B 2 J D B C We b D B 2 Control Center Control D B 2

6 Red Hat Linux DB2 Universal Database 6.1 171 D B 2 L i n u x I B M D B 2 DB2 Universal Database for L i n u x I n t e r n e t DB2 Control Center J a v a We b J a v a DB2 for Linux J D B C S Q L J N e t We b P e r l D B 2 P e r l Perl Database Interface DB2 for Linux D B 2 We b 6. 1 DB2 for Linux DB2 for Linux Index Smart Guide Performance Monitor U N I C O D E / OLE DB Microsoft Access L o t u s A p p r o a c h OLE DB DB2 Connect A S / 400 D B 2 D B 2 70 % DB2 Connect 6500 1999 I B M 5 0 % 50 000 D B 2 6. 1 b e t a D B 2 D B D B 2 6.2 DB2 Red Hat R e d H a t D B 2 D B 2 D B 2 R e d H a t L i n u x I B M L i n u x I T DB2 Personal Developer's Edition D B 2 Personal Developer's Edition for Linux D B 2 DB2 Personal Developer's Edition D B 2 Universal Database Personal Edition DB2 Personal Developer's Edition DB2 Universal Database Personal Edition D B 2 D B 2 A S / 400 DB2 Connect Personal Edition

172 Linux A S / 400 D B 2 DB2 Universal Database Personal Edition DB2 Connect Personal Edition D B 2 Control Center DB2 Software Developer Kit A P I D B 2 DB2 Connect Personal Edition L i n u x O S / 2 Wi n d o w s 9 x Windows NT h t t p //: w w w 4. i b m. c o m / s o f t w a r e / d a t a / d b 2 / l i n u x / IBM DB2 for Linux L i n u x D B 2 1) Linux 2. 0. 35 2) RPM R e d H a t 3) pdksh K o r n s h e l l 4) glibc 2. 0. 7 5) libstdc++ 2. 8. 0 r p m - q a R e d H a t 6. 0 6. 1 l i b s t d c + + 2. 9. 0 D B 2 l i b s t d c + + 2. 8. 0 l i b s t d c + + 2. 8. 0 /usr/lib 6.2.1 DB2 Red Hat 5.2 6.0 Red Hat 5.2 6. 0 D B 2 D B p d k s h Red Hat 5.2 6. 0 / R e d H a t / R P M S r p m - i Gnome KDE Red Hat p d k s h - 5. 2. 13-3 r p m - i p d k s h - 5. 2. 1 3-3 Red Hat5.2 6. 0 D B 2 6.2.2 DB2 Red Hat 6.1 Red Hat 6.1 Red Hat D B 2 d b 2 s t a r t D B 2 D B 2 D B I B M R e d H a t D B 2 Red Hat 6.1 D B 2 We b

6 Red Hat Linux DB2 Universal Database 6.1 173 D B 2 D B 2 1999 D B 2 I B M Red Hat 6.1 D B 2 D B 2 F i x P a c k F i x P a c k 2 Red Hat6.1 D B 2 F i x P a c k 1 D B 2 DB2 FixPack ftp://ftp. software.ibm. com/ps/products/ db2/fixes/english-us/db2linuxv61 F i x P a c k F P F i x P a c k F i x P a c k 2 F P 2 D B 2 DB2 FixPack 1) r o o t 2) f t p :// f t p. s o f t w a r e. i b m. c o m / p s / p r o d u c t s / d b 2 / t o o l s I B M f t p 3) Red Hat 6.1 D B 2 d b 2 r h 61 f i x. t g z D B 2 d b 2 r h 61 g a f i x. t g x d b 2 r h 61 g a f i x. t g x D B 2 Red Hat 6.1 4) tar xvf patch_name p a t c h _ n a m e D B 2 5) r e a d m e. t x t 6. 1 D B 2 p d k s h Red Hat 6.1 /Red Hat/RPMS r p m - i Gnome KDE Red Hat 6.1 p d k s h - 5. 2. 14-1 rpm -i pdksh-5.2.14-1 Red Hat 6.1 D B 2 6.3 DB2 D B 2 D B 2 D B 2 D B D B 2 D B D B 2 d b 2 i n s t 1 d b 2 f e n c 1 d b 2 a s u s e r d e l

174 Linux D B 2 r p m D B 2 D B 2 D B 6.3.1 Red Hat DB2 Universal Database 6.1 DB2 Universal Database Workgroup Edition D B 2 C T R L - L D B 2 Red Hat C T R L - A LT- F 1 C T R L - A LT- F 7 D B 2 1) r o o t Red Hat 2) DB2Universal Database 6.1 3) Red Hat 6.1 D B 2 D B 2 D B D B 2 r e a d m e. t x t 4) mount-t iso9660 -o ro/dev/cdrom/mnt/cdrom 5) c d / m n t / c d r o m 6) Red Hat 6.1 D B 2 r e a d m e. t x t 7)./ d b 2 s e t u p D B 2 Install DB2 V6 6-1 6-1 Install DB2 V6

6 Red Hat Linux DB2 Universal Database 6.1 175 8) D B 2 DB2 UDB Workgroup Edition TA B E N T E R D B 2 H e l p 9) D B 2 D B C u s t o m i z e D B 2 6-2 6-2 DB2 Workgroup Edition Select All D B 2 Java Support Contro lcenter O K 10) DB2 Product Messages C u s t o m i z e DB2 Product Messages 6-3 O K 11) DB2 Product Library C u s t o m i z e DB2 Product Library 6-4 E n g l i s h D B 2 Control Center O K 6-3 DB2 Product Messages 6-4 DB2 Product Library

176 Linux 12) O K Create DB2 Services 6-5 13) Createa DB2 Instance DB2I nstance 6-6 DB2 Installer i n s t a n c e - o w n e r S y s t e m A d m i n i s t r a t i v e [ S Y S A D M ] S Y S A D M 6-5 Create DB2 Services 6-6 DB2 Instance

6 Red Hat Linux DB2 Universal Database 6.1 177 P a s s w o r d Verify Password field i b m d b 2 D B S Y S A D M DB2 Administration Guide 14) P r o p e r t i e s 6-7 6-7 Auto start DB2 Instance at system boot Createa sample database for DB2 Instance D B 2 SAMPLE SYSADM Authentication Ty p e Communication Protocols 15) O K 16) U D F 6-8 6-8 Fenced User i n s t a n c e - o w n e r

178 Linux O K i b m d b 2 Create DB2 Services 6-5 U D F Administration Guide 17) Create the Administration Server Administration Server Administration Server D A S Control Center Administration Server Administration Guide Administration Server 6-9 6-9 Administration Server D B 2 Administration Server i n s t a n c e - o w n e r Administration Server System Administrative S Y S A D M P a s s w o r d Verify Password O K i b m d b 2 D B D B 2 6-10 O K 6-5 Create DB2 Services 18) O K D B 2 Summary Report 6-11 Summary Report D B 2 M o r e C o n t i n u e 6-10 DB2SYSTEM Summary Report

6 Red Hat Linux DB2 Universal Database 6.1 179 Continue 6-11 Summary Report 19) C o n t i n u e 6-12 D B 2 O K C a n c e l 6-12 Warning 20) Status Report 6-13 D B 2 View Log 6-14 O K C l o s e O K D B 2

180 Linux 6-13 Status Report 6-14 6.3.2 D B 2 S A M P L E

6 Red Hat Linux DB2 Universal Database 6.1 181 S A M P L E 1) D B 2 s u - d b 2 i n s t 1 - su db2inst1 D B 2 D B 2 p r o f i l e 2) d b 2 s t a r t SQL1026N The database manager is already active. SQL 10007N Message 1 393 could not be retrieved. Reason Code: 1 e r r o r D B 2 D B D B 2 I N S TA N C E = d b 2 i n s t 1 3) S A M P L E db2 connect to sample 4) s t a ff 20 db2"select*froms taff where dept=20" "" L i n u x D B 2 5) db2 connect reset

182 Linux DB2 Workgroup Edition Control Center D B 2 6. 5 D B 2 6.4 Control Center Control Center( ) D B 2 Java Run-Time Environment J R E We b J a v a J a v a Control Center J a v a Control Center Control Center README r e a d m e. h t m / u s e r / I B M d b 2 / V 6. 1 / c c / p r i m e Control Center J a v a C o n t r o l C e n t e r 6. 5 D B 2 D B 2 Control Center 1) r o o t 2) J R EJ R E h t t p : / / w w w. s o f t w a r e. i b m. c o m / d a t a / d b 2 / Control Center J a v a 1. 1. 7 v 3 Red Hat J R E h t t p :// w w w. b l a c k d o w n. o rg / j a v a - l i n u x / m i r r o r s. h t m l B l a c k d o w n We b f t p :// m e t a l a b. u n c. e d u / p u b / l i n u x / d e v e l / l a n g / j a v a / b l a c k d o w n. o rg / J D K - 1. 1. 7 / i 386 / g l i b c / v 3 / j r e - 1. 1. 7 - v 3 - g l i b e - x 86 - n a t i v e. t a r. g z / t m p J R E n a t i v e g r e e n J a v a J R E n a t i v e D B 2 C o n t r o l C e n t e r g r e e n 3) J R E / t m p c d / t m p 4) J R E u n z i p u n t a r tar xvfz jre-1.1.7-v3-glibc-x86-native.tar.gz 5) d b 2 i n s t 1 su-db2inst1 - DB2 6) PAT H J R E / t m p / j r e 117 _ v 7 / b i n J R E

6 Red Hat Linux DB2 Universal Database 6.1 183 7) Control Center JDBC AppletS erver db2jstrt 6790 6790 4 8) Control Center db2cc 6790 Control Center 6790 JDBC Applet 9) d b 2 c c 6790 Control Center Sign On 6-15 I D d b 2 i n s t 1 I D D B 2 O K 6-15 Control Center Sign On 10) Control Center 6-16 Control Center Control Center Control Center DB2 Administration Guide 6-16 Control Center

184 Linux 6.5 DB2 D B 2 6. 2 D B 2 Red Hat D B 2 D B 2 D B D B 2 D B D B 2 d b 2 i n s t u s e r d e l D B 2 D B 2 C T R L - L D B 2 Red Hat C T R L - A LT- F 1 C T R L - A LT- F 7 DB2 Run-Time Client DB2 Administration Client DB2 Administration Client D B 2 DB2 Universal Database 6.1 DB2 Administration Client DB2 Administration Client DB2 Run- Time Client DB2 Run-Time Client DB2 and DB2 Connect Installationand Configuration Supplement DB2 Client 1) r o o t Red Hat 2) DB2 Universal Database 6.1 Red Hat6.1 D B 2 D B 2 DB2 D B 2 r e a d m e. t x t 3) mount-t iso9660-o ro/dev/cdrom/mnt/cdrom 4) c d / m n t / c d r o m Red Hat 6.1 D B 2 r e a d m e. t x t 5)./ d b 2 s e t u p D B 2 Install DB2V6 6-17 6) D B 2 DB2 Administration Client TA B E N T E R D B 2 H e l p 7) D B 2 D B C u s t o m i z e D B 2 Administration Client 6-18

6 Red Hat Linux DB2 Universal Database 6.1 185 6-17 Install DB2 V6.1 6-18 DB2 Administration Client 8) Select All D B 2 J a v a S u p p o r t Control Center O K 9) DB2 Product Messages C u s t o m i z e DB2 Product Messages 6-19 O K 6-19 DB2 Product Messages 10) DB2 Product Library C u s t o m i z e DB2 Product Library 6-20 D B 2 Control Center O K 6-20 DB2 Product Library

186 Linux 11) Create DB2 Services 6-21 D B 2 DB2 Administration Server DB2 Administration Server 6-21 DB2 Create Services 12) Createa DB2 Instance D B 2 D B 2 DB2 Instance 6-22 6-22 DB2 Instance DB2 Installer i n s t a n c e - o w n e r S y s t e m A d m i n i s t r a t i v e [ S Y S A D M ] S Y S A D M D B 2 P a s s w o r d Ve r i f y Password field O K DB2 DB2 ID i b m d b 2 D B S Y S A D M DB2 Administration Guide

6 Red Hat Linux DB2 Universal Database 6.1 187 13) O K D B 2 Summary Report 6-23 S u m m a r y R e p o r t D B 2 M o r e C o n t i n u e 6-23 Summary Report Summary Report Continue 14) C o n t i n u e 6-24 D B 2 O K C a n c e l 6-24 Warning 15) Status Report 6-25 D B 2 Vi e w L o g 6-26 O K C l o s e O K D B 2 D B Control Center

188 Linux D B 2 Control Center Control Center 6. 4 Control Center D B 2 D B 2 6-25 Status Report 6-26 6.6 DB2 DB2 D B 2 D B 2 T C P / I P D B 2 D B 2 D B 2 D B 2 D B 2 D B 2 T C P / I P D B 2 D B 2 D B D B 2 DB2 and DB2 Connect Installation and Configuration Supplement T C P / I P T C P / I P

6 Red Hat Linux DB2 Universal Database 6.1 189 D B 2 T C P / I P D B 2 D B 2 TCP/IP SO_KEEPA L I V E TCP/IP T C P / I P T C P / I DB2 Troubleshooting Guide D B 2 T C P / I P D B 2 1) T C P / I P 6-1 6-1 DB2 T C P / I P H o s t n a m e ( h o s t n a m e ) D B 2 I P d b 2 s e r v e r I PA d d r e s s ( i p _ a d d r e s s ) 9. 21. 125. 124 D B 2 h o s t n a m e ping hostname I P S e r v i c e N a m e ( s v c e n a m e ) / e t c / s e r v i c e s d b 2 c d b 2 i n s t 1 P o r t n u m b e r / P r o t o c o l 50000 / t c p ( p o r t _ n u m b e r / t c p ) S e r v e r N a m e D B 2 D B 2 D B 2 / e t c / s e r v i c e s s v c e n a m e s v c e n a m e DB2 / e t c / s e r v i c e s s v c e n a m e S Y S A D M DB2 db2get dbm cfg D B 2 s v c e n a m e d b 2 c d b 2 i n s t 1

190 Linux N o d e n a m e n o d e _ n a m e 5 0 0 0 0 D B 2 d b 2 s e r v e r D B 2 2) T C P / I P D B 2 I ping hostname ping DB2 D B 2 D B / e t c / h o s t s I P (Network Information Services N I S ) U N I X D B 2 N I S / e t c / h o s t s r o o t / e t c / h o s t s D B 2 9.21.125.124 db2server #host address for the computer db2server 9. 21. 125. 124 D B 2 I P d b 2 s e r v e r D B 2 # db2server.vnet.com vnet.com 3) / e t c / s e r v i c e s D B 2 D B D B 2 r o o t S e r v i c e N a m e T C P / I P D B 2 D B 2

6 Red Hat Linux DB2 Universal Database 6.1 191 db2cdb2inst1 50000/tcp#DB2 client service name & matching DB2 server port d b 2 c d b 2 i n s t 1 D B 2 5 0000 D B 2 s v c e n a m e D B 2 / e t c / s e r v i c e s D B 2 D B 2 t c p # (Network Information Services N I S ) U N I X D B 2 N I S / e t c / s e r v i c e s 4) T C P / I P D B 2 D B D B 2 D B 2 n o d e _ n a m e h o s t n a m e I P s v c e n a m e T C P / I P a) S Y S A D M S Y S C T R L I D d b 2 i n s t 1 su - su-db2inst1 DB2 DB2 b) T C P / I P d b 2 s e r v e r d b 2 s e r v e r d b 2 c d b 2 i n s t 1 d b 2 n o d e I P 9. 21. 125. 124 50000 5) D B 2 D B D B 2 D B 2 D B

192 Linux a) 6-2 6-2 D a t a b a s e n a m e D B 2 S A M P L E ( d a t a b a s e _ n a m e ) d a t a b a s e _ a l i a s D a t a b a s e a l i a s D B 2 S A M P L E D B 2 D B 2 S A M P L E ( d a t a b a s e _ a l i a s ) N o d e n a m e D B 2 D B 2 D B 2 d b 2 s e r v e r ( n o d e _ n a m e ) b) S Y S A D M S Y S C T R L I D d b 2 i n s t 1 su - su-db2inst1 DB2 DB2 c) d b 2 s e r v e r S A M P L E S A M P L E 6) D B 2 D B 2

6 Red Hat Linux DB2 Universal Database 6.1 193 DB2 DB2 db2inst1 db2start a) d b 2 i n s t 1 I D su - su-db2inst1 DB2 DB2 b) db2 connect to database_alias user userid using p a s s w o r d d a t a b a s e _ a l i a s D B 2 D B 2 u s e r i d D B 2 I D d b 2 i n s t 1 p a s s w o r d u s e r i d D B 2 D B 2 I D u s e r i d p a s s w o r d D B 2 I D D B 2 S A M P L E D B 2 S A M P L E d b 2 i n s t 1 db2 connect to sample DB2 userid password DB2 I D d b 2 i n s t 1 D B 2 I D D B userid password c) s t a ff 20 db2"select*from staff where dept=20" "" L i n u x * D B 2

194 Linux d) db2 connect reset D B 2 D B 2 D B 2 D B 2 1) / e t c / s e r v i c e s / e t c / h o s t s 2) I P D B 2 d b 2 i n s t 1 db2 list node directory 3) d b 2 i n s t 1 db2 list database directory N o d e D B 2 4) D B 2 D B D B 2 D B 2 S A M P L E D B S A M P L E Troubleshooting Guide 6.7 D B 2 D B 2 T C P / I P L A N D B 2 L i n u x L i n u L i n u x We b e - m a i l L i n u x I T L i n u x L i n u x I P O L i n u x Red Hat D B 2

6 Red Hat Linux DB2 Universal Database 6.1 195 6.8 D B 2 D B 6-27 6-27 DB2 D B 2 / t m p /. d b 2 i n s t. l c k D B 2 r m / t m p /. d b 2 i n s t. l c k D B 2 D B 2 A d m i n i s t r a t i o n S e r v e r 6-28 6-28 Administration Server Administration Server Administration Server Administration Server D B 2

196 Linux d b 2 s t a r t SQL10007N Message" 1393"could notberetrieved.reasoncode:"1" D B 2 d b 2 s t a r t D B 2 D B 2 I N S TA N C E D B 2 - s u export DB2INSTA N C E = d b 2 i n s t 1 d b 2 i n s t 1 D B 2 D B 2 d b 2 c d b 2 i n s t 1 5 0 0 0 0 s v c e n a m e port number D B 2 D B D B 2 / e t c / s e r v i c e s d b 2 c d b 2 i n s t 1 50000 D B 2 / e t c / s e r v i c e s D B 2 D B 2 D B 2 6-29 6-29 DB2 DB2 D B 2 D B 2 I n s t a l l D B 2 C r e a t e D B 2 D B Administration Server D B 2

6 Red Hat Linux DB2 Universal Database 6.1 197 Administration Server D B 2 D B 2 Administration Server D B 2 / D B 2 D B 2 D B 2 D B 2 DB2 and DB2 Connect Installationand Configuration Supplement DB2A dministration Guide DB2 Data Movement and Utilities Guide D B 2 I B M L i n u x D B 2 I B M h t t p :// w w w - 4. i b m. c o m / s o f t w a r e / d a t a / d b 2 / h t t p : / / w w w - 4. i b m. c o m / s o f t w a r e / i s / D B 2 A S / 400 D B 2 D B 2 S Q L u n i n s t a l l D B 2 m p / l i n u x / DB2 Troubleshooting Guide DB2 Connect Quick Beginnings DB2 SQL Getting Started Guide S Q L R e f e r e n c e DB2 and DB2Connect Installation and Configuration Supplement D B 2 Quick Beginnings for UNIX