1:参考启动脚本
#!/bin/bash
./clearTmp.sh
ps -ef | grep weblogic | awk '{print $2}' | xargs kill -9
./startWebLogic.sh
-------------------------------------
#!/bin/sh
# WARNING: This file is created by the Configuration Wizard.
# Any changes to this script may be lost when adding extensions to this configuration.
DOMAIN_HOME="/app/uat_java/domain"
#${DOMAIN_HOME}/bin/startWebLogic.sh $*
logFile=start.log.`date +%Y%m%d%H%M%S`
nohup ${DOMAIN_HOME}/bin/startWebLogic.sh $* > ${DOMAIN_HOME}/log/${logFile} &
2:连接远程数据库db2
db2 catalog tcpip node p570 remote 11.1.7.123 server 50000
db2 catalog db PASO at node p570
db2 connect to PASO USER paso using paso
db2 catalog db PASO at node p570
db2 connect to PASO USER paso using paso
3:?
DB2LOOK -d PASO -e -a -i paso -w paso -o DB_DLL.sql
db2look -d DEPARTMENT -z myscm1 -e -o db2look.sql 导出schema
db2look -d DEPARTMENT -z myscm1 -e -o db2look.sql 导出schema
db2 import from D:\tmp\db2export\tab1.ixf of ixf insert into test
db2 -tvf import.sql
创建模式
CREATE SCHEMA MGR;在操作系统登录用户与db2数据库登录用户一致时创建模式,否则报错,创建成功后此用户成为模式的拥有者
CREATE SCHEMA <name> AUTHORIZATION <name>
删除模式之前要先删下面的表
select 'drop table '||rtrim(TABSCHEMA)||'.'||TABNAME||';' from syscat.tables where tabschema='MGR'
DROP SCHEMA <name> RESTRICT
select SCHEMANAME,OWNER from syscat.schemata 查看模式拥有者
jdbc:db2://localhost:50000/sample:currentSchema=MGR; 指定模式,分号不能少。
CREATE SCHEMA MGR;在操作系统登录用户与db2数据库登录用户一致时创建模式,否则报错,创建成功后此用户成为模式的拥有者
CREATE SCHEMA <name> AUTHORIZATION <name>
删除模式之前要先删下面的表
select 'drop table '||rtrim(TABSCHEMA)||'.'||TABNAME||';' from syscat.tables where tabschema='MGR'
DROP SCHEMA <name> RESTRICT
select SCHEMANAME,OWNER from syscat.schemata 查看模式拥有者
jdbc:db2://localhost:50000/sample:currentSchema=MGR; 指定模式,分号不能少。
4:
删列后表可能变为不可使用,使用reorg解锁,reorg不能通过sql执行,sql中可以使用SYSPROC.ADMIN_CMD
CALL SYSPROC.ADMIN_CMD('$cmd$')
CALL SYSPROC.ADMIN_CMD('$cmd$')
5:
alter table tableName move;针对空表不导出
exp hongbo/hongbo@orcl file=d:\hongbo.dmp owner=(hongbo)
imp app1/app1@orcl file=d:\hongbo.dmp full=y ignore=y
exp hongbo/hongbo@orcl file=d:\hongbo.dmp owner=(hongbo)
imp app1/app1@orcl file=d:\hongbo.dmp full=y ignore=y
wmsys.wm_concat group拼接