db2安装完成之后如何创建db2的SAMPLE数据库呢?
一、切换到/opt/ibm/db2/V10.5/bin目录,这个目录是db2安装的默认路径,在这个目录下有个名为“db2sampl”的脚本,直接执行就行了。
[db2opt1@node112 bin]$ ./db2sampl Creating database "SAMPLE"... Connecting to database "SAMPLE"... Creating tables and data in schema "DB2OPT1"... Creating tables with XML columns and XML data in schema "DB2OPT1"... 'db2sampl' processing complete.
二、连接刚才创建好的sample数据库:
[db2opt1@node112 bin]$ db2 connect to sample user db2opt1using db2opt1 Database Connection Information Database server = DB2/LINUXX8664 10.5.8 SQL authorization ID = DB2OPT1 Local database alias = SAMPLE
三、查看一下当前使用的schema db2opt1下面的表,可以看到在当前schema下面已经有表了:
[db2opt1@node112 bin]$ db2 list tables for schema db2opt1 Table/View Schema Type Creation time ------------------------------- --------------- ----- -------------------------- ACT DB2OPT1 T 2018-01-09-14.51.36.663678 ADEFUSR DB2OPT1 S 2018-01-09-14.51.40.153130 CATALOG DB2OPT1 T 2018-01-09-14.51.49.384638 CL_SCHED DB2OPT1 T 2018-01-09-14.51.34.511819 CUSTOMER DB2OPT1 T 2018-01-09-14.51.48.759168 DEPARTMENT DB2OPT1 T 2018-01-09-14.51.34.936798
四、随便找个表查询下数据玩下:
[db2ijcxt@xdecisiondb bin]$ db2 "select * from staff" ID NAME DEPT JOB YEARS SALARY COMM ------ --------- ------ ----- ------ --------- --------- 10 Sanders 20 Mgr 7 98357.50 - 20 Pernal 20 Sales 8 78171.25 612.45 30 Marenghi 38 Mgr 5 77506.75 - 40 O'Brien 38 Sales 6 78006.00 846.55 50 Hanes 15 Mgr 10 80659.80 - 60 Quigley 38 Sales - 66808.30 650.25 70 Rothman 15 Sales 7 76502.83 1152.00 80 James 20 Clerk - 43504.60 128.20 90 Koonitz 42 Sales 6 38001.75 1386.70 100 Plotz 42 Mgr 7 78352.80 - 110 Ngan 15 Clerk 5 42508.20 206.60
五、完全没有问题,db2的示例数据库SAMPLE创建成功