DB2 Installation Tutorials

DB2 Linux Installation Deployment

1 Extracting files

tar -zxvf db2_v101_linuxx64_expc. tar. gz

2 Switching paths

CD expc/

3 Starting the installation program

./db2_install

It then asks the user if the software is installed in the/opt/ibm/db2/v10.1 directory, select Yes

4 Creating user names and user groups

-M--m-g db2fadm1 db2fenc1

5 Modifying user passwords

passwd Db2inst1 passwd db2fenc1

6 Installing License (product license)

Cd/opt/ibm/db2/v10. 1/adm/chmod755 *

# The following path is the DB2 installation when the directory is unpacked

When successful, the following information is displayed

 for inch " /opt/ibm/db2/v10.1/license/en_us.iso88591 "

6 Creating a DB instance

Cd/opt/ibm/db2/v10. 1/instance/chmod755 -R *. 50000 -u db2fenc1 db2inst1

After successful execution, the following information is displayed

 More " /tmp/db2icrt.log.82277 " . Dbi1070i program DB2ICRT completed successfully.

7 Creating a sample Database

su - db2inst1db2sampl

After successful, the screen output the following information

 Creating database  " sample   "  ... Connecting to database   " sample  Span style= "COLOR: #800000" > "  ... Creating tables and data  in  schema  " Span style= "COLOR: #800000" >db2inst1   "  ... Creating tables with XML columns and XML data  in  schema "  db2inst1   "  ...   " db2sampl   " processing complete. 

Continue to execute command

" SELECT * from staff "

The screen outputs the following information to prove that the installation was successful

ID NAME DEPT JOB years SALARY COMM------ --------- ------ ----- ------ --------- ---------TenSanders -Mgr7 98357.50- -Pernal -Sales8 78171.25 612.45 -Marenghi -Mgr5 77506.75- +O'Brien Sales 6 78006.00 846.55 -Hanes theMgrTen 80659.80- -Quigley -Sales-66808.30 650.25 -Rothman theSales7 76502.83 1152.00 theJames -Clerk-43504.60 128.20 -Koonitz theSales6 38001.75 1386.70 -Plotz theMgr7 78352.80- theNgan theClerk5 42508.20 206.60 -Naughton -Clerk-42954.75 180.00 theYamaguchi theClerk6 40505.90 75.60 $FrayeWuyiMgr6 91150.00- MaxWilliamsWuyiSales6 79456.50 637.65 theMolinareTenMgr7 82959.20- theKermisch theClerk4 42258.50 110.10 theAbrahams -Clerk3 37009.75 236.50 theSneider -Clerk8 34252.75 126.50 $Scoutten theClerk-41508.60 84.20 AboutLuTenMgrTen 90010.00- -SmithWuyiSales7 87654.50 992.80 theLundquistWuyiClerk3 83369.80 189.65 -DanielsTenMgr5 79260.25- -WheelerWuyiClerk6 74460.00 513.30260JonesTenMgr A 81234.00- theLea theMgr9 88555.50-280Wilson theSales9 78674.50 811.50290Quill -MgrTen 89818.00- -Davis -Sales5 65454.50 806.10310Graham theSales - 71000.00 200.30 theGonzales theSales4 76858.20 844.00 theBurke theClerk1 49988.00 55.50340Edwards -Sales7 67844.00 1285.00 -Gafney -Clerk5 43030.50 188.00 *Record (s) selected.

Reference blog:
https://my.oschina.net/cwdong8/blog/132953

DB2 Installation Tutorials