Access denied | www.uuuwg.com used Cloudflare to restrict access
Please enable cookies.
What happened?
The owner of this website (www.uuuwg.com) has banned your access based on your browser's signature (3dc292e8f2b55158-ua98).当前位置： >>
DB2 9.7安装和配置(完善)
DB2 安装和配置1 DB2 安装和配置1.1 拷贝 DB2 安装包到 OPT 下[root@localhost opt]# scp DB2_WSE_97_Linux_x86.tar.gz root@192.168.1.239:/opt The authenticity of host '192.168.1.239 (192.168.1.239)' can't be established. RSA key fingerprint is 31:14:ff:22:04:6c:50:13:7d:a5:5d:ee:04:f3:56:c6. Are you sure you want to continue connecting (yes)? yes Warning: Permanently added '192.168.1.239' (RSA) to the list of known hosts. root@192.168.1.239's password: db2v82_32_linux_2.6_ESE.tar 100% 410MB 45.6MB/s 00:091.2 解压安装包到当前目录tar -xvf DB2_WSE_97_Linux_x86.tar.gz1.3 检查并设置字符集安装 DB2 8.7 时，应该用 [root@localhost 334_ESE_LNX26_32_NLV]# vi /etc/sysconfig/i18n#LANG=&zh_CN.UTF-8&LANG=&zh_CN.GB18030&LANGUAGE=&zh_CN.GB18030:zh_CN.GB2312:zh_CN&LC_C TYPE=zn_CN.GB18030lC_TIME=en_US.UTF-8[root@localhost ]# source /etc/sysconfig/i18n1.4 安装 DB2[root@localhost wse]# ./DB2_install指定下列一个或多个关键字 （以空格分开）以安装 DB2 产品。选择 输入否 WAS注意必须完全一致，不能退格1.5 创建组groupadd db2grp1 groupadd db2fgrp1 groupadd dasadm11.6 创建用户useradd -g db2grp1 db2inst1 useradd -g db2fgrp1 db2fenc1 useradd -g dasadm1 dasusr11.7 设置密码passwd db2inst1 passwd db2fenc1 passwd dasusr11.8 创建实例cd /opt/IBM/db2/V8.1/instance/ ./db2icrt -p 50000 -u db2fenc1 db2inst1 安装成功将显示： DBI1070I Program db2icrt completed successfully.注释:1.9 指定端口 50000./dascrt -u dasusr1编辑/etc/services 添加一行： DB2_TMINST 50000/tcp su db2inst1 db2set db2comm = tcpip su root1.10 拷贝安装许可证到 DB2 目录 license这是单独的许可证 db2wse_c.lic cp /opt/db2ese.lic /opt/IBM/db2/V8.1/license/ su db2inst1 db2licm -a /opt/IBM/db2/V8.1/license/db2ese.lic[db2inst1@localhost license]$ db2licm -a /opt/IBM/DB2/V8.1 lib/ license/ [db2inst1@localhost license]$ db2licm -a /opt/IBM/DB2/V8.1/License/DB2ese.lic DBI1402I License added successfully.DBI1426I This product is now licensed for use as specified in the License Acceptance and License Information documents pertaining to the licensed copy of this product. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE ACCEPTANCE AND LICENSE INFORMATION DOCUMENTS, LOCATED IN THE FOLLOWING DIRECTORY: /opt/IBM 2/V8.1 cense/zh_CN.gbk[db2inst1@localhost license]$2 恢复 DB2 数据库王府井新门店2.1 拷贝数据库备份启动数据库db2start chmod 777 [备份文件名] 日志目录赋予 777 权限。例如 /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR SQL00001 可能不同。 su db2inst1 db2 restore db 【数据库名】 （e.g. scmv3in1 for VIP1） from 【备份文件所在目录】taken at 03 其中数据库名是指的是备份数据库文件的名称。 还原数据库应以备份出来的数据库文件时间戳为准 、03 是备份出来的数据库文件的时间戳，如果提示成功 db2 rollforward db 【数据库名】to end of logs and stop 当执行以上命令会出现解决办：把原来服务器商的日志复制到当前服务器的/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ 目录 中 ，并设置权权限 更改所有者以及所宿主 使用 chown db2inst1：dbgrp1 S0003553.LOG S0003554.LOG， 然后在执行命令提示成功 db2 rollforward db 【数据库名】complete已经完成恢复[db2inst1@localhost opt]$ db2 rollforward db scmv3in1 to end of logs Rollforward Status Input database alias = scmv3in1 Number of nodes have returned status = 1 Node number = 0 Rollforward status = DB working Next log file to be read = S0023101.LOG Log files processed = S0023101.LOG - S0023101.LOG Last committed transaction = -15.11.05.000I The ROLLFORWARD command completed successfully.[db2inst1@localhost opt]$ db2 rollforward db scmv3in1 complete Rollforward Status Input database alias = scmv3in1 Number of nodes have returned status = 1 Node number = 0 Rollforward status = not pending Next log file to be read = Log files processed = S0023101.LOG - S0023101.LOG Last committed transaction = -15.11.05.000I The ROLLFORWARD command completed successfully.测试数据库是否工作，连接数据库： db2 connect to scmv3in1 user scmuser using scmusering2.2 恢复后设置字符集db2set db2codepage=1386 db2 terminate db2 connect to 【数据库名】 user 【用户名】 using 【密码】 db2 connect to scmv2 user scmuser using scmusering查数据库字符集及其他信息[db2inst1@localhost ~]$ db2 get db cfg for scmv2 Database Configuration for Database scmv2 Database configuration release level Database release level Database territory Database code page Database code set Database country/region code Database collating sequence Alternate collating sequence Number compatibility Varchar2 compatibility = 0x0d00 = 0x0d00 = = = = = (ALT_COLLATE) = = = US 1208 UTF-8 1 IDENTITY OFF OFFDate compatibility Database page size Dynamic SQL Query management Statement concentrator Discovery support for this database= OFF = 4096 (DYN_QUERY_MGMT) = DISABLE (STMT_CONC) = OFF (DISCOVER_DB) = ENABLE = = = = = = = = NO 5 1 NO 0 SYSTEM 10 20Restrict access Default query optimization class (DFT_QUERYOPT) Degree of parallelism (DFT_DEGREE) Continue upon arithmetic exceptions (DFT_SQLMATHWARN) Default refresh age (DFT_REFRESH_AGE) Default maintained table types for opt (DFT_MTTB_TYPES) Number of frequent values retained (NUM_FREQVALUES) Number of quantiles retained (NUM_QUANTILES) Decimal floating point rounding mode Backup pending All committed transactions have been written to disk Rollforward pending Restore pending Multi-page file allocation enabled Log retain for recovery status User exit for logging status Self tuning memory (SELF_TUNING_MEM) Size of database shared memory (4KB) (DATABASE_MEMORY) Database memory threshold (DB_MEM_THRESH) Max storage for lock list (4KB) (LOCKLIST) Percent. of lock lists per application (MAXLOCKS) Package cache size (4KB) (PCKCACHESZ) Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) Sort list heap (4KB) (SORTHEAP) Database heap (4KB) Catalog cache size (4KB) Log buffer size (4KB) Utilities heap size (4KB) Buffer pool size (pages) SQL statement heap (4KB) Default application heap (4KB) Application Memory Size (4KB) Statistics heap size (4KB) (DBHEAP) (CATALOGCACHE_SZ) (LOGBUFSZ) (UTIL_HEAP_SZ) (BUFFPAGE) (STMTHEAP) (APPLHEAPSZ) (APPL_MEMORY) (STAT_HEAP_SZ)(DECFLT_ROUNDING) = ROUND_HALF_EVEN = NO = YES = NO = NO = YES = RECOVERY = NO = = = = = = = = = = = = = = = = = OFF AUTOMATIC(2 10 (MAXAPPLS*8)
AUTOMATIC(1200) (MAXAPPLS*5) 8
AUTOMATIC(2048) AUTOMATIC(256) AUTOMATIC(10016) AUTOMATIC(4384)Interval for checking deadlock (ms) Lock timeout (sec) Changed pages threshold Number of asynchronous page cleaners Number of I/O servers Index sort flag Sequential detect flag Default prefetch size (pages) Track modified pages Default number of containers Default tablespace extentsize (pages) Max number of active applications Average number of active applications Max DB files open per application(DLCHKTIME) = 10000 (LOCKTIMEOUT) = -1 (CHNGPGS_THRESH) (NUM_IOCLEANERS) (NUM_IOSERVERS) (INDEXSORT) (SEQDETECT) (DFT_PREFETCH_SZ) = = = = = = 60 AUTOMATIC(1) AUTOMATIC(3) YES YES AUTOMATIC(TRACKMOD) = OFF = 1 (DFT_EXTENT_SZ) = 32 (MAXAPPLS) = AUTOMATIC(333) (AVG_APPLS) = AUTOMATIC(1) (MAXFILOP) = 30720 = 1000 = 3 = 2 = = = = = = = = = = = = = = = = = = = = = =Log file size (4KB) (LOGFILSIZ) Number of primary log files (LOGPRIMARY) Number of secondary log files (LOGSECOND) Changed path to log files (NEWLOGPATH) Path to log files /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ Overflow log path (OVERFLOWLOGPATH) Mirror log path (MIRRORLOGPATH) First active log file Block log on disk full (BLK_LOG_DSK_FUL) Block non logged operations (BLOCKNONLOGGED) Percent max primary log space by transaction (MAX_LOG) Num. of active log files for 1 active UOW(NUM_LOG_SPAN) Group commit count (MINCOMMIT) Percent log file reclaimed before soft chckpt (SOFTMAX) Log retain for recovery enabled (LOGRETAIN) User exit for logging enabled (USEREXIT) HADR HADR HADR HADR HADR HADR HADR HADR HADR database role local host name local service name remote host name remote service name instance name of remote server timeout value log write synchronization mode peer window duration (seconds)S0005768.LOG NO NO 0 0 1 100 RECOVERY OFF STANDARD(HADR_LOCAL_HOST) (HADR_LOCAL_SVC) (HADR_REMOTE_HOST) (HADR_REMOTE_SVC) (HADR_REMOTE_INST) (HADR_TIMEOUT) (HADR_SYNCMODE) (HADR_PEER_WINDOW)120 NEARSYNC 0First log archive method Options for logarchmeth1(LOGARCHMETH1) = LOGRETAIN (LOGARCHOPT1) =Second log archive method (LOGARCHMETH2) = OFF Options for logarchmeth2 (LOGARCHOPT2) = Failover log archive path (FAILARCHPATH) = Number of log archive retries on error (NUMARCHRETRY) = 5 Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20 Vendor options (VENDOROPT) = Auto restart enabled (AUTORESTART) Index re-creation time and redo index build (INDEXREC) Log pages during index build (LOGINDEXBUILD) Default number of loadrec sessions (DFT_LOADREC_SES) Number of database backups to retain (NUM_DB_BACKUPS) Recovery history retention (days) (REC_HIS_RETENTN) Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) TSM TSM TSM TSM management class node name owner password (TSM_MGMTCLASS) (TSM_NODENAME) (TSM_OWNER) (TSM_PASSWORD) (AUTO_MAINT) (AUTO_DB_BACKUP) (AUTO_TBL_MAINT) (AUTO_RUNSTATS) (AUTO_STMT_STATS) (AUTO_STATS_PROF) (AUTO_PROF_UPD) (AUTO_REORG) (AUTO_REVAL) (CUR_COMMIT) (DEC_TO_CHAR_FMT) (ENABLE_XMLCHAR) (WLM_COLLECT_INT) (MON_REQ_METRICS) (MON_ACT_METRICS) (MON_OBJ_METRICS) (MON_UOW_DATA) (MON_LOCKTIMEOUT) (MON_DEADLOCK) (MON_LOCKWAIT) (MON_LW_THRESH) = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = OFF OFF OFF OFF OFF OFF OFF OFF DISABLED DISABLED V95 YES 0 NONE NONE NONE NONE NONE NONE NONE 5000000 ON SYSTEM (RESTART) OFF 1 12 366 OFFAutomatic maintenance Automatic database backup Automatic table maintenance Automatic runstats Automatic statement statistics Automatic statistics profiling Automatic profile updates Automatic reorganization Auto-Revalidation Currently Committed CHAR output with DECIMAL input Enable XML Character operations WLM Collection Interval (minutes) Monitor Collect Settings Request metrics Activity metrics Object metrics Unit of work events Lock timeout events Deadlock events Lock wait events Lock wait event threshold SMTP Server(SMTP_SERVER) =
racktom.com
copyright &copyright 。共享资料网内容来自网络，如有侵犯请联系客服。&>&db2ese_c.lic
DB2 V9.7 license linux
db2ese_c.lic
DB2 V9.7 license linux
上传大小：998B
emal:/opt/ibm/db2/V9.7/license # db2licm -l
Product name:
&DB2 Enterprise Server Edition&
Expiry date:
Product identifier:
Version information:
Enforcement policy:
&Soft Stop&
Product name:
&DB2 Connect Server&
Expiry date:
Product identifier:
&db2consv&
Version information:
Concurrent connect user policy:
&Disabled&
Enforcement policy:
&Soft Stop&
db2ese_c.lic拷贝到/opt/ibm/db2/V9.7/license下
emal:/opt/ibm/db2/V9.7/adm # db2licm -a ../license/db2ese_c.lic
License added successfully.
This product is now licensed for use as outlined in your License Agreement.
USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: &/opt/ibm/db2/V9.7/license/en_US.iso88591&
再用db2licm -l查看
貌似只破解了一部分，但是可以连数据库了
db2icomm@emal:~/Desktop& db2licm -l
Product name:
&DB2 Enterprise Server Edition&
License type:
&CPU Option&
Expiry date:
&Permanent&
Product identifier:
Version information:
Enforcement policy:
&Soft Stop&
DB2 Performance Optimization ESE: &Not licensed&
DB2 Storage Optimization:
&Not licensed&
DB2 Advanced Access Control:
&Not licensed&
IBM Homogeneous Replication ESE:
&Not licensed&
Product name:
&DB2 Connect Server&
Expiry date:
Product identifier:
&db2consv&
Version information:
Concurrent connect user policy:
&Disabled&
Enforcement policy:
&Soft Stop&
...展开收缩
综合评分：5（16位用户评分）
下载个数：
{%username%}回复{%com_username%}{%time%}\
/*点击出现回复框*/
$(".respond_btn").on("click", function (e) {
$(this).parents(".rightLi").children(".respond_box").show();
e.stopPropagation();
$(".cancel_res").on("click", function (e) {
$(this).parents(".res_b").siblings(".res_area").val("");
$(this).parents(".respond_box").hide();
e.stopPropagation();
/*删除评论*/
$(".del_comment_c").on("click", function (e) {
var id = $(e.target).attr("id");
$.getJSON('/index.php/comment/do_invalid/' + id,
function (data) {
if (data.succ == 1) {
$(e.target).parents(".conLi").remove();
alert(data.msg);
$(".res_btn").click(function (e) {
var parentWrap = $(this).parents(".respond_box"),
q = parentWrap.find(".form1").serializeArray(),
resStr = $.trim(parentWrap.find(".res_area_r").val());
console.log(q);
//var res_area_r = $.trim($(".res_area_r").val());
if (resStr == '') {
$(".res_text").css({color: "red"});
$.post("/index.php/comment/do_comment_reply/", q,
function (data) {
if (data.succ == 1) {
var $target,
evt = e || window.
$target = $(evt.target || evt.srcElement);
var $dd = $target.parents('dd');
var $wrapReply = $dd.find('.respond_box');
console.log($wrapReply);
//var mess = $(".res_area_r").val();
var mess = resS
var str = str.replace(/{%header%}/g, data.header)
.replace(/{%href%}/g, 'http://' + window.location.host + '/user/' + data.username)
.replace(/{%username%}/g, data.username)
.replace(/{%com_username%}/g, data.com_username)
.replace(/{%time%}/g, data.time)
.replace(/{%id%}/g, data.id)
.replace(/{%mess%}/g, mess);
$dd.after(str);
$(".respond_box").hide();
$(".res_area_r").val("");
$(".res_area").val("");
$wrapReply.hide();
alert(data.msg);
}, "json");
/*删除回复*/
$(".rightLi").on("click", '.del_comment_r', function (e) {
var id = $(e.target).attr("id");
$.getJSON('/index.php/comment/do_comment_del/' + id,
function (data) {
if (data.succ == 1) {
$(e.target).parent().parent().parent().parent().parent().remove();
$(e.target).parents('.res_list').remove()
alert(data.msg);
//填充回复
function KeyP(v) {
var parentWrap = $(v).parents(".respond_box");
parentWrap.find(".res_area_r").val($.trim(parentWrap.find(".res_area").val()));
评论共有16条
很好用，好用
看完了，还可以的，学到不少
非常好用，谢谢！
上传时间：积分/C币：3
shenny2002
上传时间：积分/C币：3
上传时间：积分/C币：3
上传时间：积分/C币：10
fabbychips
上传时间：积分/C币：5
上传时间：积分/C币：3
上传时间：积分/C币：10
humadivinity
上传时间：积分/C币：3
上传时间：积分/C币：3
上传时间：积分/C币：0
上传时间：积分/C币：0
上传时间：积分/C币：3
hooboorcom
上传时间：积分/C币：3
tianyashijian
上传时间：积分/C币：3
feixiangyuan
上传时间：积分/C币：3
上传时间：积分/C币：10
BlueSpectre
上传时间：积分/C币：3
lanyayinxiang
上传时间：积分/C币：3
lanyayinxiang
上传时间：积分/C币：3
lanyayinxiang
上传时间：积分/C币：3
上传者其他资源
testng,6.11 jar包
Confluence 导出PDF时，中文无法显示，宋体字体包
计算广告 互联网商业变现的市场与技术
fiddler4抓包工具
GeckoDriver64
VIP会员动态
CSDN下载频道资源及相关规则调整公告V11.10
下载频道用户反馈专区
下载频道积分规则调整V1710.18
spring mvc+mybatis+mysql+maven+bootstrap 整合实现增删查改简单实例.zip
资源所需积分/C币
当前拥有积分
当前拥有C币
扫码关注并点击右下角获取下载码
输入下载码
为了良好体验，不建议使用迅雷下载
db2ese_c.lic
DB2 V9.7 license linux
会员到期时间：
剩余下载个数：
剩余C币：0
剩余积分：0
为了良好体验，不建议使用迅雷下载
积分不足！
资源所需积分/C币
当前拥有积分
您可以选择
程序员的必选
绿色安全资源
资源所需积分/C币
当前拥有积分
当前拥有C币
(仅够下载10个资源)
为了良好体验，不建议使用迅雷下载
资源所需积分/C币
当前拥有积分
当前拥有C币
为了良好体验，不建议使用迅雷下载
资源所需积分/C币
当前拥有积分
当前拥有C币
您的积分不足，将扣除 10 C币
为了良好体验，不建议使用迅雷下载
你当前的下载分为234。
你还不是VIP会员
开通VIP会员权限，免积分下载
你下载资源过于频繁，请输入验证码
您因违反CSDN下载频道规则而被锁定帐户，如有疑问，请联络:!
若举报审核通过，可奖励5下载分
被举报人：
fabbychips
举报的资源分：
请选择类型
资源无法下载
资源无法使用
标题与实际内容不符
含有危害国家安全内容
含有反动色情等内容
含广告内容
版权问题，侵犯个人或公司的版权
*详细原因：
db2ese_c.lic
DB2 V9.7 license linux