Install dependency packages:
1
2
3
|
$
sudo
apt-get
install
libstdc++6:i386
$
sudo
apt-get
install
libpam0g:i386
$
sudo
apt-get
install
libaio1
|
Uncompress the tarball:
1
2
3
|
$
tar
-xf v10.5_linuxx64_expc.
tar
.gz
$
cd
exec
$
sudo
.
/db2setup
|
Next, ...
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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
$
su
- db2inst1
$
cd
sqllib
$ . db2profile
$ db2start
$ db2sampl
$ db2 connect to sample
Database Connection Information
Database server = DB2
/LINUXX8664
10.5.5
SQL authorization ID = DB2INST2
Local database
alias
= SAMPLE
$ db2 list tables
Table
/View
Schema Type Creation
time
------------------------------- --------------- ----- --------------------------
ACT DB2INST2 T 2015-03-22-16.39.32.984953
ADEFUSR DB2INST2 S 2015-03-22-16.39.51.276708
CATALOG DB2INST2 T 2015-03-22-16.40.26.918692
CL_SCHED DB2INST2 T 2015-03-22-16.38.58.081500
CUSTOMER DB2INST2 T 2015-03-22-16.40.14.581512
DEPARTMENT DB2INST2 T 2015-03-22-16.38.59.900669
DEPT DB2INST2 A 2015-03-22-16.39.04.065165
EMP DB2INST2 A 2015-03-22-16.39.08.317704
EMPACT DB2INST2 A 2015-03-22-16.39.32.983063
EMPLOYEE DB2INST2 T 2015-03-22-16.39.04.066016
EMPMDC DB2INST2 T 2015-03-22-16.39.54.359440
EMPPROJACT DB2INST2 T 2015-03-22-16.39.31.111145
EMP_ACT DB2INST2 A 2015-03-22-16.39.32.984224
EMP_PHOTO DB2INST2 T 2015-03-22-16.39.08.319122
EMP_RESUME DB2INST2 T 2015-03-22-16.39.15.861029
INVENTORY DB2INST2 T 2015-03-22-16.40.10.965029
IN_TRAY DB2INST2 T 2015-03-22-16.39.36.736349
ORG DB2INST2 T 2015-03-22-16.39.38.488446
PRODUCT DB2INST2 T 2015-03-22-16.40.05.406467
PRODUCTSUPPLIER DB2INST2 T 2015-03-22-16.40.38.307623
PROJ DB2INST2 A 2015-03-22-16.39.26.861271
PROJACT DB2INST2 T 2015-03-22-16.39.26.862400
PROJECT DB2INST2 T 2015-03-22-16.39.22.691152
PURCHASEORDER DB2INST2 T 2015-03-22-16.40.20.931702
SALES DB2INST2 T 2015-03-22-16.39.42.007483
STAFF DB2INST2 T 2015-03-22-16.39.40.154365
STAFFG DB2INST2 T 2015-03-22-16.39.47.478081
SUPPLIERS DB2INST2 T 2015-03-22-16.40.32.846871
VACT DB2INST2 V 2015-03-22-16.39.44.259450
VASTRDE1 DB2INST2 V 2015-03-22-16.39.44.848543
VASTRDE2 DB2INST2 V 2015-03-22-16.39.44.984556
VDEPMG1 DB2INST2 V 2015-03-22-16.39.44.568045
VDEPT DB2INST2 V 2015-03-22-16.39.43.804835
VEMP DB2INST2 V 2015-03-22-16.39.44.059233
VEMPDPT1 DB2INST2 V 2015-03-22-16.39.44.685860
VEMPLP DB2INST2 V 2015-03-22-16.39.46.077147
VEMPPROJACT DB2INST2 V 2015-03-22-16.39.44.457204
VFORPLA DB2INST2 V 2015-03-22-16.39.45.543735
VHDEPT DB2INST2 V 2015-03-22-16.39.43.967370
VPHONE DB2INST2 V 2015-03-22-16.39.45.934022
VPROJ DB2INST2 V 2015-03-22-16.39.44.192579
VPROJACT DB2INST2 V 2015-03-22-16.39.44.374853
VPROJRE1 DB2INST2 V 2015-03-22-16.39.45.103118
VPSTRDE1 DB2INST2 V 2015-03-22-16.39.45.210473
VPSTRDE2 DB2INST2 V 2015-03-22-16.39.45.400333
VSTAFAC1 DB2INST2 V 2015-03-22-16.39.45.671703
VSTAFAC2 DB2INST2 V 2015-03-22-16.39.45.809835
47 record(s) selected.
$ db2
"select * from emp"
EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE JOB EDLEVEL SEX BIRTHDATE SALARY BONUS COMM
------ ------------ ------- --------------- -------- ------- ---------- -------- ------- --- ---------- ----------- ----------- -----------
000010 CHRISTINE I HAAS A00 3978 01
/01/1995
PRES 18 F 08
/24/1963
152750.00 1000.00 4220.00
000020 MICHAEL L THOMPSON B01 3476 10
/10/2003
MANAGER 18 M 02
/02/1978
94250.00 800.00 3300.00
000030 SALLY A KWAN C01 4738 04
/05/2005
MANAGER 20 F 05
/11/1971
98250.00 800.00 3060.00
000050 JOHN B GEYER E01 6789 08
/17/1979
MANAGER 16 M 09
/15/1955
80175.00 800.00 3214.00
000060 IRVING F STERN D11 6423 09
/14/2003
MANAGER 16 M 07
/07/1975
72250.00 500.00 2580.00
000070 EVA D PULASKI D21 7831 09
/30/2005
MANAGER 16 F 05
/26/2003
96170.00 700.00 2893.00
000090 EILEEN W HENDERSON E11 5498 08
/15/2000
MANAGER 16 F 05
/15/1971
89750.00 600.00 2380.00
000100 THEODORE Q SPENSER E21 0972 06
/19/2000
MANAGER 14 M 12
/18/1980
86150.00 500.00 2092.00
000110 VINCENZO G LUCCHESSI A00 3490 05
/16/1988
SALESREP 19 M 11
/05/1959
66500.00 900.00 3720.00
000120 SEAN O'CONNELL A00 2167 12
/05/1993
CLERK 14 M 10
/18/1972
49250.00 600.00 2340.00
000130 DELORES M QUINTANA C01 4578 07
/28/2001
ANALYST 16 F 09
/15/1955
73800.00 500.00 1904.00
000140 HEATHER A NICHOLLS C01 1793 12
/15/2006
ANALYST 18 F 01
/19/1976
68420.00 600.00 2274.00
000150 BRUCE ADAMSON D11 4510 02
/12/2002
DESIGNER 16 M 05
/17/1977
55280.00 500.00 2022.00
000160 ELIZABETH R PIANKA D11 3782 10
/11/2006
DESIGNER 17 F 04
/12/1980
62250.00 400.00 1780.00
000170 MASATOSHI J YOSHIMURA D11 2890 09
/15/1999
DESIGNER 16 M 01
/05/1981
44680.00 500.00 1974.00
000180 MARILYN S SCOUTTEN D11 1682 07
/07/2003
DESIGNER 17 F 02
/21/1979
51340.00 500.00 1707.00
000190 JAMES H WALKER D11 2986 07
/26/2004
DESIGNER 16 M 06
/25/1982
50450.00 400.00 1636.00
000200 DAVID BROWN D11 4501 03
/03/2002
DESIGNER 16 M 05
/29/1971
57740.00 600.00 2217.00
000210 WILLIAM T JONES D11 0942 04
/11/1998
DESIGNER 17 M 02
/23/2003
68270.00 400.00 1462.00
000220 JENNIFER K LUTZ D11 0672 08
/29/1998
DESIGNER 18 F 03
/19/1978
49840.00 600.00 2387.00
000230 JAMES J JEFFERSON D21 2094 11
/21/1996
CLERK 14 M 05
/30/1980
42180.00 400.00 1774.00
000240 SALVATORE M MARINO D21 3780 12
/05/2004
CLERK 17 M 03
/31/2002
48760.00 600.00 2301.00
000250 DANIEL S SMITH D21 0961 10
/30/1999
CLERK 15 M 11
/12/1969
49180.00 400.00 1534.00
000260 SYBIL P JOHNSON D21 8953 09
/11/2005
CLERK 16 F 10
/05/1976
47250.00 300.00 1380.00
000270 MARIA L PEREZ D21 9001 09
/30/2006
CLERK 15 F 05
/26/2003
37380.00 500.00 2190.00
000280 ETHEL R SCHNEIDER E11 8997 03
/24/1997
OPERATOR 17 F 03
/28/1976
36250.00 500.00 2100.00
000290 JOHN R PARKER E11 4502 05
/30/2006
OPERATOR 12 M 07
/09/1985
35340.00 300.00 1227.00
000300 PHILIP X SMITH E11 2095 06
/19/2002
OPERATOR 14 M 10
/27/1976
37750.00 400.00 1420.00
000310 MAUDE F SETRIGHT E11 3332 09
/12/1994
OPERATOR 12 F 04
/21/1961
35900.00 300.00 1272.00
000320 RAMLAL V MEHTA E21 9990 07
/07/1995
FIELDREP 16 M 08
/11/1962
39950.00 400.00 1596.00
000330 WING LEE E21 2103 02
/23/2006
FIELDREP 14 M 07
/18/1971
45370.00 500.00 2030.00
000340 JASON R GOUNOT E21 5698 05
/05/1977
FIELDREP 16 M 05
/17/1956
43840.00 500.00 1907.00
200010 DIAN J HEMMINGER A00 3978 01
/01/1995
SALESREP 18 F 08
/14/1973
46500.00 1000.00 4220.00
200120 GREG ORLANDO A00 2167 05
/05/2002
CLERK 14 M 10
/18/1972
39250.00 600.00 2340.00
200140 KIM N NATZ C01 1793 12
/15/2006
ANALYST 18 F 01
/19/1976
68420.00 600.00 2274.00
200170 KIYOSHI YAMAMOTO D11 2890 09
/15/2005
DESIGNER 16 M 01
/05/1981
64680.00 500.00 1974.00
200220 REBA K JOHN D11 0672 08
/29/2005
DESIGNER 18 F 03
/19/1978
69840.00 600.00 2387.00
200240 ROBERT M MONTEVERDE D21 3780 12
/05/2004
CLERK 17 M 03
/31/1984
37760.00 600.00 2301.00
200280 EILEEN R SCHWARTZ E11 8997 03
/24/1997
OPERATOR 17 F 03
/28/1966
46250.00 500.00 2100.00
200310 MICHELLE F SPRINGER E11 3332 09
/12/1994
OPERATOR 12 F 04
/21/1961
35900.00 300.00 1272.00
200330 HELENA WONG E21 2103 02
/23/2006
FIELDREP 14 F 07
/18/1971
35370.00 500.00 2030.00
200340 ROY R ALONZO E21 5698 07
/05/1997
FIELDREP 16 M 05
/17/1956
31840.00 500.00 1907.00
42 record(s) selected.
|
版权声明:原创作品,如需转载,请注明出处。否则将追究法律责任