DB
文章平均质量分 79
lianghyan
喜欢旅游,不喜欢固定一层不变的生活
展开
-
docker db2
https://hub.docker.com/r/ibmcom/db2docker run -itd --name mydb2 --privileged=true -p 50000:50000 -e LICENSE=accept -e DB2INST1_PASSWORD=testdb -e DBNAME=testdb -v /scan/db2docker:/database ibmcom/db2docker start mydb2docker exec -ti mydb2 bash -c "su原创 2020-06-05 15:43:30 · 112 阅读 · 0 评论 -
websphere liberty 配置
1. 拷贝db2jcc.jar到目录 ${wlp_home}/usr/shared/resources2. 修改server.xml <featureManager> <feature>javaee-8.0</feature> <feature>localConnector-1.0</feature> <feature>jndi-1.0</feature> ...原创 2020-05-14 17:32:11 · 733 阅读 · 0 评论 -
在Mac上安装db2 driver
Mac上安装 db2 driver不是很难, 难的是找到Mac版本,费了两天才发现最新版本里有支持Mac的版本, 一直执着于db2 10.5.简直是自己挖坑啊!欲哭无泪!在此链接中找到最新版本https://www.ibm.com/support/pages/node/323035db2 drivers - DB2 v11.1.4.5. 。选择Mac OSX版本下载v11.1.4fp5_macos_dsdriver.dmg到本地, 按住ctrl键双击,下载文件, dsd...原创 2020-05-13 14:40:48 · 1490 阅读 · 3 评论 -
msql命令集
关闭server:mysqladmin -u root shutdown启动server:mysqld --console启动server:mysqld-nt --default-character-set=gbk --console 应用在往mysql写中文字符时,总是乱码,是什么问题呢?mysqld --default-character-set=gb2312 --con原创 2007-11-02 17:04:00 · 1829 阅读 · 0 评论 -
db2 sql error due to 'from'
com.ibm.db2.jcc.am.SqlException: ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE. SQLCODE=-4700, SQLSTATE=56038, DRIVER=3.57.82 at com.ibm.db2.jcc.am.bd.a(bd.java:679)de原创 2014-09-03 15:03:09 · 475 阅读 · 0 评论 -
db2 with as
with bb(next_step_sid, step_sid) as(select next_step_sid, step_sid from t_nextstep),aa(next_step_sid,step_sid) as ( values( 11,12)) select * from bb UNION select * from aa原创 2014-10-20 16:44:06 · 3156 阅读 · 0 评论 -
MongoDB simple command
1. download free Mongodb from https://www.mongodb.com/download-center#community, I use windows version2. install mongodb3. start mongodbD:\dev\MongoDB\bin>mongod4. use command lineD:\dev\原创 2016-05-06 17:20:39 · 609 阅读 · 0 评论