- 浏览: 156268 次
- 性别:
- 来自: 徐州
文章分类
- 全部博客 (94)
- 电脑小技巧 (6)
- 工具 (5)
- html javascript ajax (14)
- 面试题目 (1)
- 数据库 (13)
- linux (3)
- java (21)
- spring 中的bean 大小写 (1)
- lucene compass (1)
- windows7安装 (2)
- 使用WinPE安装Windows 7 (1)
- delphi (1)
- spring3 mvc ,aop ,spring security (0)
- spring3 mvc (3)
- aop (3)
- spring security (2)
- InetAddress (1)
- ipv6 (1)
- video 视频 (0)
- 地址 (1)
- collabnet (1)
- spring (1)
- phonegap (1)
- JRebel (1)
- ionic (1)
- scriptx (1)
- flex (1)
最新评论
-
snihcel:
expression="execution(* or ...
spring3 mvc 添加aop支持(Spring MVC 注解下Controller 的AOP) -
xuxiangpan888:
weaponhuang 写道确定AOP能对conttoler进 ...
spring3 mvc 添加aop支持(Spring MVC 注解下Controller 的AOP) -
weaponhuang:
确定AOP能对conttoler进行拦截????这个我搞了好几 ...
spring3 mvc 添加aop支持(Spring MVC 注解下Controller 的AOP) -
huangyunbin:
你在你的项目中试验过吗?我在我的项目中试了下,不行啊。然后我是 ...
spring3 mvc 添加aop支持(Spring MVC 注解下Controller 的AOP) -
梅花簪:
方法斯蒂芬
spring3 mvc 添加aop支持(Spring MVC 注解下Controller 的AOP)
LOAD CLIENT FROM 'E:\1\data\ECMS_APPLY.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_APPLY"; LOAD CLIENT FROM 'E:\1\data\ECMS_APPLY_PRIV.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_APPLY_PRIV"; LOAD CLIENT FROM 'E:\1\data\ECMS_APPLY_PROCESS.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_APPLY_PROCESS"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_ARTICLE1.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IDENTITYOVERRIDE INSERT INTO "XXP"."ECMS_CONTENT_ARTICLE1"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_BMGG.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_BMGG"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_CBJ.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_CBJ"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_FIELDS.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_FIELDS"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_GG.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_GG"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_INFO.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_INFO"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_PUBLISH_1.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_PUBLISH_1"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_PUBLISH_2.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_PUBLISH_2"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_PUBLISH_3.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_PUBLISH_3"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_PUBLISH_4.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_PUBLISH_4"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_TABLES.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_TABLES"; LOAD CLIENT FROM 'E:\1\data\ECMS_CONTENT_ZXFT.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_CONTENT_ZXFT"; LOAD CLIENT FROM 'E:\1\data\ECMS_EXCHANGE_ITEM.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_EXCHANGE_ITEM"; LOAD CLIENT FROM 'E:\1\data\ECMS_EXCHANGE_LEAVE.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_EXCHANGE_LEAVE"; LOAD CLIENT FROM 'E:\1\data\ECMS_EXCHANGE_PRIV.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_EXCHANGE_PRIV"; LOAD CLIENT FROM 'E:\1\data\ECMS_EXCHANGE_PROCESS.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_EXCHANGE_PROCESS"; LOAD CLIENT FROM 'E:\1\data\ECMS_EXCHANGE_TYPE.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_EXCHANGE_TYPE"; LOAD CLIENT FROM 'E:\1\data\ECMS_FILES.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_FILES"; LOAD CLIENT FROM 'E:\1\data\ECMS_NODES.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_NODES"; LOAD CLIENT FROM 'E:\1\data\ECMS_NODE_SERIAL.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_NODE_SERIAL"; LOAD CLIENT FROM 'E:\1\data\ECMS_PRIV.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_PRIV"; LOAD CLIENT FROM 'E:\1\data\ECMS_PRIVILEGES.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_PRIVILEGES"; LOAD CLIENT FROM 'E:\1\data\ECMS_RELATED_DOC.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IDENTITYOVERRIDE INSERT INTO "XXP"."ECMS_RELATED_DOC"; LOAD CLIENT FROM 'E:\1\data\ECMS_ROLE.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_ROLE"; LOAD CLIENT FROM 'E:\1\data\ECMS_SERIAL.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_SERIAL"; LOAD CLIENT FROM 'E:\1\data\ECMS_SITES.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_SITES"; LOAD CLIENT FROM 'E:\1\data\ECMS_TEMPLATE_NODE.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_TEMPLATE_NODE"; LOAD CLIENT FROM 'E:\1\data\ECMS_USER.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ECMS_USER"; LOAD CLIENT FROM 'E:\1\data\INFORMATION_1.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IDENTITYOVERRIDE INSERT INTO "XXP"."INFORMATION_1"; LOAD CLIENT FROM 'E:\1\data\INFORMATION_2.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IDENTITYOVERRIDE INSERT INTO "XXP"."INFORMATION_2"; LOAD CLIENT FROM 'E:\1\data\INFORMATION_3.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IDENTITYOVERRIDE INSERT INTO "XXP"."INFORMATION_3"; LOAD CLIENT FROM 'E:\1\data\INFORMATION_4.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IDENTITYOVERRIDE INSERT INTO "XXP"."INFORMATION_4"; LOAD CLIENT FROM 'E:\1\data\LOG.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."LOG"; LOAD CLIENT FROM 'E:\1\data\LOGIN.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."LOGIN"; LOAD CLIENT FROM 'E:\1\data\ORGAN.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."ORGAN"; LOAD CLIENT FROM 'E:\1\data\SYN_NODE.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."SYN_NODE"; LOAD CLIENT FROM 'E:\1\data\USER_NODE.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."USER_NODE"; LOAD CLIENT FROM 'E:\1\data\USER_ORGAN.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."USER_ORGAN"; LOAD CLIENT FROM 'E:\1\data\USER_PRIV.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."USER_PRIV"; LOAD CLIENT FROM 'E:\1\data\USER_ROLE.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."USER_ROLE"; LOAD CLIENT FROM 'E:\1\data\VOTE_ADMIN_REPLY.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."VOTE_ADMIN_REPLY"; LOAD CLIENT FROM 'E:\1\data\VOTE_ITEM.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."VOTE_ITEM"; LOAD CLIENT FROM 'E:\1\data\VOTE_OPTION.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."VOTE_OPTION"; LOAD CLIENT FROM 'E:\1\data\VOTE_PRIV.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."VOTE_PRIV"; LOAD CLIENT FROM 'E:\1\data\VOTE_REPLY.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."VOTE_REPLY"; LOAD CLIENT FROM 'E:\1\data\VOTE_SUBJECT.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."VOTE_SUBJECT"; LOAD CLIENT FROM 'E:\1\data\VOTE_TYPE.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."VOTE_TYPE"; LOAD CLIENT FROM 'E:\1\data\VOTE_USERINFO.del' OF DEL LOBS FROM 'E:\1\data\' MODIFIED BY LOBSINFILE DELPRIORITYCHAR IMPLIEDDECIMAL INSERT INTO "XXP"."VOTE_USERINFO";
export导出文件中由于有换行符而无法正确的load和import
load的时候加modified by DELPRIORITYCHAR
MODIFIED BY DELPRIORITYCHAR.J$Zar z}0Db2默认load优先级策略为,record delimiter, character delimiter, column delimiter,这样record delimiter得优先级最高,所以原始文件如果有换行的话load就认为是新的record,如果用户在某些情况下行里面包含了换行符(比如论坛里面的一条帖子,不可能把换行符删掉的),就必须用delprioritychar改变默认的优先级别,确保""之间的数据不管有没有换行符都被认为是同一条记录Vq]d"zD6d3Y]0例:LOAD CLIENT FROM 'F:s1.del' OF DEL MODIFIED BY DELPRIORITYCHAR INSERT INTO DB2ADMIN.ZXTABLES
在建表时,对于一些表的主键设置为自增,这样在对表进行数据插入、修改、删除时,会方便很多,但是一旦表的主键作为其他表的外键,那么在对数据进行迁移时,就会出现数据不匹配的问题,如何解决对于自增字段的数据和数据文件匹配问题呢。在深入研究load后发现,load对于自增数据的导入,有三种方式:IDENTITYIGNOR、IDENTITYMISSING、IDENTITYOVERRIDE。在实际测试后,对于IDENTITYIGNOR、IDENTITYMISSING,自增字段按照计数器累加;IDENTITYOVERRIDE,自增字段按照数据文件的数据导入表中。
加上IDENTITYOVERRIDE后,Load将把数据文件中的数值,填充到表的自增字段中。
5. 对于自增序列(GENERATED ALWAYS)
MODIFIED BY IDENTITYOVERRIDE:此参数可以理解为,采用文件load文件中的自增值做为表自增序列的值,这样就能保证对于自增序列有业务意义,或者关联逻辑(主外键关联)的情况下保证数据的一致,个人对此命令屡试不爽
例: LOAD CLIENT FROM 'F:s1.del' OF DEL MODIFIED BY IDENTITYOVERRIDE INSERT INTO DB2ADMIN.ztables;
6. 对于自增序列(GENERATED by default)
GENERATED by default可以直接通过一般的导入方式加载数据,不过有时候会有一点点小问题,自增序列没有进行分配,也就是说,原来表有50条记录,自增序列的下一次分配值为50,当你已经导入了1000条记录进去了,然后发现自增序列的下一次分配值还是为50,这种事不经常发生,但是偶尔会发生一次,比较郁闷的是,当表继续插入数据的时候,下一次分配就会发生冲突,尤其是如果自增建为主键的时候,会违反唯一约束。
解决办法:首先找到这个序列分配的最大值,select max(id) from tablea;
然后用下边这个命令,alter table tablea alter column restart with max(id)+1
相关链接:
http://blog.itpub.net/694276/viewspace-423017/
http://www.db2china.net/club/viewthread.php?tid=24299
Db2 文件导入导出常见命令总结
Db2 的数据迁移,最常用的就是导入导出功能,而导入导出的命令貌似简单,实则内含玄机,千变万化,稍不留神,则错误百出,这儿就工作中常用到的命令,总结了一下,分享给大家!欢迎大家踊跃拍砖!
当然在这以前,我觉得有必要提及一点关于导入导出基础的知识!
DEL:界定的ASCII文件,行分隔符和列分隔符将数据分开。
ASC:定长的ASCII文件,行按照行分割符分开,列定长。
PC/IXF:只能用来在db2之间导数据,根据类型数字值被打包成十进制或者二进制,字符被保存为ASCII,只保存变量已经使用了的长度,文件中包括表的定义和表的数据。
WSF:工作表方式导入导出,这种格式的文件类型用的比较少。
Db2中对不同的数据导入导出方式,支持不同的文件类型,这里个人觉得很有必要注意下的。
文件类型 Import export load
-------------------------------------------------------
定界 支持 支持 支持
非定界 支持 不支持 支持
Ixf 支持 支持 支持
Wsf工作表 支持 支持 不支持
关于3种导入导出操作进行简单的介绍:
export:导出数据,支持IXF,DEL或WSF
import:导入数据,可以向表中导入数据,支持上面提到的4种文件类型。
load:导入数据,功能和import基本相同。支持以上说的几种文件类型。
关于Export
这个其实比较简单,没啥好说的,一般命令:export to filename of filetype select x from xx where ;就ok了,这里需要注意的是:
1. 关于不同字符集的导出
MODIFIED BY CODEPAGE=
Exprot to filename.del for del MODIFIED BY CODEPAGE=1386 select … from …where …;
这里,在数据从数据库倒出来的时候就会做一个数据库代码页的转换
2.时间字段格式化的
MODIFIED BY TIMESTAMPFORMAT="yyyy-mm-dd hh:mm:ss tt"
例:Exprot to filename.del for del MODIFIED BY TIMESTAMPFORMAT="yyyy-mm-dd hh:mm:ss tt" select … from …where …;
关于Import
1.Import模式的介绍
CREATE/INSERT/INSERT_UPDATE/REPLACE/REPLACE_CREATE
CREATE :首先创建目标表和它的索引,然后将数据导入到新表中。该选项惟一支持的文件格式是 PC/IXF。还可以指定新表所在表空间的名称
INSERT :将导入的数据插入表中。目标表必须已经存在。
INSERT_UPDATE :将数据插入表中,或者更新表中具有匹配主键的行。目标表必须已经存在,并且定义了一个主键。
REPLACE :删除所有已有的数据,并将导入的数据插入到一个已有的目标表中。
REPLACE_CREATE :如果目标表已经存在,则导入实用程序删除已有的数据,并插入新的数据,就像 REPLACE 选项那样。如果目标表还没有定义,那么首先创建这个表以及它的相关索引,然后再导入数据。正如您可能想像的那样,输入文件必须是 PC/IXF 格式的文件,因为那种格式包含对导出表的结构化描述。如果目标表是被一个外键引用的一个父表,那么就不能使用 REPLACE_CREATE。
2. 批量提交
COMMITCOUNT,保证insert的数据在COMMITCOUNT以后进行一次commit,这对于大数据量的导入文件来说是一个不错的方法,
例:Import from filename of del COMMITCOUNT 50000 insert into tabname;
3. 批量插入
MODIFIED BY COMPOUND把文件中的 COMPOUND 行记录作为一组一起导入,这个操作可以和上边的批量提交一起使用,比较理想。
例:Import from filename of del MODIFIED BY COMPOUND =50 insert into tabname;
4. 导入记录限制
ROWCOUNT:只导入rowcount 条数据,有时候,业务逻辑需要只导入部分数据,那么ROWCOUNT是一个不错的选择,只是在我的测试中ROWCOUNT一直没有起过作用,呵呵,谁熟悉这里,帮我完善下。
例:Import from filename of del ROWCOUNT 10000 insert into tabname;
5. 导入起点
RESTARTCOUNT:从导入文件的第RESTARTCOUNT条记录开始导入
例:Import from filename of del RESTARTCOUNT 55 ROWCOUNT 10000 insert into tabname;--从55条开始,导入10000条数据
6. 有警告数据的条数限制
WARNINGCOUNT:当导入的数据中,有警告或错误(例如类型不匹配,列不对应等造成的)并且条数超过WARNINGCOUNT是就会停止import。
例:Import from filename of del WARNINGCOUNT 10 insert into tabname;
7. 禁止发出行警告
MODIFIED BY NOROWWARNINGS
例:Import from filename of del MODIFIED BY NOROWWARNINGS WARNINGCOUNT 10 insert into tabname;
8. LOB 文件
LOBS FROM :指出LOB的路径
例:Import from filename of del LOBS FROM ‘/home’ MODIFIED BY NOROWWARNINGS WARNINGCOUNT 10 insert into tabname;
9. 对于自增序列(GENERATED ALWAYS)
建议不要对自增序列的表进行import操作,因为import对于自增序列,只有MODIFIED BY IDENTITYIGNORE和MODIFIED BY IDENTITYMISSING的2中操作,这2中操作都会改变自增序列的原值,这样如果导出表和表之间有基于自增序列的关联关系的话,就失去了数据本身的意义,所以建议尽量少用基于import的自增表的操作,那该怎么做?可以用load老代替import,我们下来在load的操作中会讲到!
关于Load
1. 字符串间隔,列间隔,小数点表示
CHARDEL/COLDEL/DECPT
例:LOAD CLIENT FROM 'F:s1.del' OF DEL MODIFIED BY CHARDEL(COLDEL= DECPT? INSERT INTO "DB2ADMIN"."ZXTABLES"
2.数据库记录中存在换行符,导致数据无法装入的情况
MODIFIED BY DELPRIORITYCHAR
Db2默认load优先级策略为,record delimiter, character delimiter, column delimiter,这样record delimiter得优先级最高,所以原始文件如果有换行的话load就认为是新的record,如果用户在某些情况下行里面包含了换行符(比如论坛里面的一条帖子,不可能把换行符删掉的),就必须用delprioritychar改变默认的优先级别,确保""之间的数据不管有没有换行符都被认为是同一条记录
例:LOAD CLIENT FROM 'F:s1.del' OF DEL MODIFIED BY DELPRIORITYCHAR INSERT INTO DB2ADMIN.ZXTABLES
3.load后表空间暂挂的处理
Copy YES/ NONRECOVERABLE
对于DMS表空间,load默认为copy NO 模式,此模式下,load完成后,表空间会处于暂挂状态,这时候只能查表中的数据,需要对表空间进行一次备份,才可以对表进行update、insert等操作,那么我们可以使用如上2个命令,对于Copy YES,load完成以后会自动进行一次备份操作;NONRECOVERABLE 指出load不可恢复,此命令符不会产生表空间暂挂,也不会自动进行表空间备份,但是他有一个缺点就是,不能恢复,当数据库进行回滚的时候,不能还原,危险等级还是比较高一点,不过个人觉得也NONRECOVERABLE比较实用。
例:LOAD CLIENT FROM 'F:s1.del' OF DEL INSERT INTO DB2ADMIN.ZXTABLES NONRECOVERABLE
LOAD CLIENT FROM 'F:s1.del' OF DEL INSERT INTO DB2ADMIN.ZXTABLES COPY YES
4. load IXF类型文件到多分区数据库
partitioned db configmode load_only_verify_part part_file_location
当数据在2个不同数量节点的数据库之间移动,如果还想使用load来进行IXF的数据装载就比较棘手了,当时查遍IBM的官方文档均无所获,正郁郁不安时,狼出现了,给支了一招,现分享给大家。
首先,把ixf文件复制和分区数量相同的文件,并后缀.000(分区号),
比如,2个分区,那么我需要把原来的a.ixf,拷贝2个,并命名为a.ixf.000以及a.ixf.001
然后,load from staff.ixf of ixf replace into t1 partitioned db configmode load_only_verify_part part_file_location xxxx(part_file_location为a.ixf.000所在的目录),当然如果在unix下的话,可以通过ln –s 来做一个连接也行。
5. 对于自增序列(GENERATED ALWAYS)
MODIFIED BY IDENTITYOVERRIDE:此参数可以理解为,采用文件load文件中的自增值做为表自增序列的值,这样就能保证对于自增序列有业务意义,或者关联逻辑(主外键关联)的情况下保证数据的一致,个人对此命令屡试不爽
例: LOAD CLIENT FROM 'F:s1.del' OF DEL MODIFIED BY IDENTITYOVERRIDE INSERT INTO DB2ADMIN.ztables;
6. 对于自增序列(GENERATED by default)
GENERATED by default可以直接通过一般的导入方式加载数据,不过有时候会有一点点小问题,自增序列没有进行分配,也就是说,原来表有50条记录,自增序列的下一次分配值为50,当你已经导入了1000条记录进去了,然后发现自增序列的下一次分配值还是为50,这种事不经常发生,但是偶尔会发生一次,比较郁闷的是,当表继续插入数据的时候,下一次分配就会发生冲突,尤其是如果自增建为主键的时候,会违反唯一约束。
解决办法:首先找到这个序列分配的最大值,select max(id) from tablea;
然后用下边这个命令,alter table tablea alter column restart with max(id)+1
7.
ROWCOUNT/WARNINGCOUNT
这个同IMPORT
8.terminate,restart
如果load的过程中出了点故障,比如连接被force掉了等,这时连接查询表数据会报错SQL0668N,原因码3,这时可以通过带有terminate的load命令来进行处理!
LOAD CLIENT FROM 'F:s1.del' OF DEL terminate INTO DB2ADMIN.ztables;
9. set integrity 命令
如果表上有约束,那么给表load数据以后,一般连接表的时候都会报错,SQL0668N,原因码1,这说明该表处于“设置完整性暂挂无访问”状态,那么需要如下命令来操作。
Set integrity for schema.tablename immediate checked;
10.提高导入导出速度的数据库参数
CONFIGURATION:应用程序堆大小,该参数指示可由Backup,restore,load及装入恢复应用程序同事使用的最大内存量,看帖子上有介绍,这个值可以设置为10000*cpu数量。
db2_all "DB2 UPDATE DATABASE CONFIGURATION USING UTIL_HEAP_SZ 113486"
ixf 导出导入
-- Start of generated script for 10.161.100.180-SRS2-SRS (db2test) -- Jun-27-2014 at 10:10:22 EXPORT TO 'H:\xudata\srs2\ECMS_APPLY.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_APPLY"; #SYNC 10; EXPORT TO 'H:\xudata\srs2\ECMS_APPLY_PRIV.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_APPLY_PRIV"; #SYNC 20; EXPORT TO 'H:\xudata\srs2\ECMS_APPLY_PROCESS.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_APPLY_PROCESS"; #SYNC 30; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_ARTICLE1.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_ARTICLE1"; #SYNC 40; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_BMGG.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_BMGG"; #SYNC 50; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_CBJ.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_CBJ"; #SYNC 60; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_FIELDS.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_FIELDS"; #SYNC 70; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_GG.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_GG"; #SYNC 80; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_INFO.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_INFO"; #SYNC 90; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_PUBLISH_1.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_PUBLISH_1"; #SYNC 100; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_PUBLISH_2.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_PUBLISH_2"; #SYNC 110; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_PUBLISH_3.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_PUBLISH_3"; #SYNC 120; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_PUBLISH_4.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_PUBLISH_4"; #SYNC 130; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_TABLES.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_TABLES"; #SYNC 140; EXPORT TO 'H:\xudata\srs2\ECMS_CONTENT_ZXFT.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_CONTENT_ZXFT"; #SYNC 150; EXPORT TO 'H:\xudata\srs2\ECMS_EXCHANGE_ITEM.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_EXCHANGE_ITEM"; #SYNC 160; EXPORT TO 'H:\xudata\srs2\ECMS_EXCHANGE_LEAVE.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_EXCHANGE_LEAVE"; #SYNC 170; EXPORT TO 'H:\xudata\srs2\ECMS_EXCHANGE_PRIV.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_EXCHANGE_PRIV"; #SYNC 180; EXPORT TO 'H:\xudata\srs2\ECMS_EXCHANGE_PROCESS.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_EXCHANGE_PROCESS"; #SYNC 190; EXPORT TO 'H:\xudata\srs2\ECMS_EXCHANGE_TYPE.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_EXCHANGE_TYPE"; #SYNC 200; EXPORT TO 'H:\xudata\srs2\ECMS_FILES.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_FILES"; #SYNC 210; EXPORT TO 'H:\xudata\srs2\ECMS_NODES.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_NODES"; #SYNC 220; EXPORT TO 'H:\xudata\srs2\ECMS_NODE_SERIAL.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_NODE_SERIAL"; #SYNC 230; EXPORT TO 'H:\xudata\srs2\ECMS_PRIV.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_PRIV"; #SYNC 240; EXPORT TO 'H:\xudata\srs2\ECMS_PRIVILEGES.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_PRIVILEGES"; #SYNC 250; EXPORT TO 'H:\xudata\srs2\ECMS_RELATED_DOC.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_RELATED_DOC"; #SYNC 260; EXPORT TO 'H:\xudata\srs2\ECMS_ROLE.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_ROLE"; #SYNC 270; EXPORT TO 'H:\xudata\srs2\ECMS_SERIAL.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_SERIAL"; #SYNC 280; EXPORT TO 'H:\xudata\srs2\ECMS_SITES.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_SITES"; #SYNC 290; EXPORT TO 'H:\xudata\srs2\ECMS_TEMPLATE_NODE.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_TEMPLATE_NODE"; #SYNC 300; EXPORT TO 'H:\xudata\srs2\ECMS_USER.ixf' OF IXF SELECT * FROM "DB2TEST"."ECMS_USER"; #SYNC 310; EXPORT TO 'H:\xudata\srs2\INFORMATION_1.ixf' OF IXF SELECT * FROM "DB2TEST"."INFORMATION_1"; #SYNC 320; EXPORT TO 'H:\xudata\srs2\INFORMATION_2.ixf' OF IXF SELECT * FROM "DB2TEST"."INFORMATION_2"; #SYNC 330; EXPORT TO 'H:\xudata\srs2\INFORMATION_3.ixf' OF IXF SELECT * FROM "DB2TEST"."INFORMATION_3"; #SYNC 340; EXPORT TO 'H:\xudata\srs2\INFORMATION_4.ixf' OF IXF SELECT * FROM "DB2TEST"."INFORMATION_4"; #SYNC 350; EXPORT TO 'H:\xudata\srs2\LOG.ixf' OF IXF SELECT * FROM "DB2TEST"."LOG"; #SYNC 360; EXPORT TO 'H:\xudata\srs2\LOGIN.ixf' OF IXF SELECT * FROM "DB2TEST"."LOGIN"; #SYNC 370; EXPORT TO 'H:\xudata\srs2\ORGAN.ixf' OF IXF SELECT * FROM "DB2TEST"."ORGAN"; #SYNC 380; EXPORT TO 'H:\xudata\srs2\SYN_NODE.ixf' OF IXF SELECT * FROM "DB2TEST"."SYN_NODE"; #SYNC 390; EXPORT TO 'H:\xudata\srs2\USER_NODE.ixf' OF IXF SELECT * FROM "DB2TEST"."USER_NODE"; #SYNC 400; EXPORT TO 'H:\xudata\srs2\USER_ORGAN.ixf' OF IXF SELECT * FROM "DB2TEST"."USER_ORGAN"; #SYNC 410; EXPORT TO 'H:\xudata\srs2\USER_PRIV.ixf' OF IXF SELECT * FROM "DB2TEST"."USER_PRIV"; #SYNC 420; EXPORT TO 'H:\xudata\srs2\USER_ROLE.ixf' OF IXF SELECT * FROM "DB2TEST"."USER_ROLE"; #SYNC 430; EXPORT TO 'H:\xudata\srs2\VOTE_ADMIN_REPLY.ixf' OF IXF SELECT * FROM "DB2TEST"."VOTE_ADMIN_REPLY"; #SYNC 440; EXPORT TO 'H:\xudata\srs2\VOTE_ITEM.ixf' OF IXF SELECT * FROM "DB2TEST"."VOTE_ITEM"; #SYNC 450; EXPORT TO 'H:\xudata\srs2\VOTE_OPTION.ixf' OF IXF SELECT * FROM "DB2TEST"."VOTE_OPTION"; #SYNC 460; EXPORT TO 'H:\xudata\srs2\VOTE_PRIV.ixf' OF IXF SELECT * FROM "DB2TEST"."VOTE_PRIV"; #SYNC 470; EXPORT TO 'H:\xudata\srs2\VOTE_REPLY.ixf' OF IXF SELECT * FROM "DB2TEST"."VOTE_REPLY"; #SYNC 480; EXPORT TO 'H:\xudata\srs2\VOTE_SUBJECT.ixf' OF IXF SELECT * FROM "DB2TEST"."VOTE_SUBJECT"; #SYNC 490; EXPORT TO 'H:\xudata\srs2\VOTE_TYPE.ixf' OF IXF SELECT * FROM "DB2TEST"."VOTE_TYPE"; #SYNC 500; EXPORT TO 'H:\xudata\srs2\VOTE_USERINFO.ixf' OF IXF SELECT * FROM "DB2TEST"."VOTE_USERINFO"; #SYNC 510; -- End of generated script for 10.161.100.180-SRS2-SRS (db2test)
LOAD CLIENT FROM 'E:\1\srsixf\ECMS_APPLY.ixf' OF IXF INSERT INTO "XXP"."ECMS_APPLY"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_APPLY_PRIV.ixf' OF IXF INSERT INTO "XXP"."ECMS_APPLY_PRIV"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_APPLY_PROCESS.ixf' OF IXF INSERT INTO "XXP"."ECMS_APPLY_PROCESS"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_ARTICLE1.ixf' OF IXF MODIFIED BY IDENTITYOVERRIDE INSERT INTO "XXP"."ECMS_CONTENT_ARTICLE1"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_BMGG.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_BMGG"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_CBJ.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_CBJ"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_FIELDS.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_FIELDS"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_GG.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_GG"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_INFO.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_INFO"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_PUBLISH_1.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_PUBLISH_1"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_PUBLISH_2.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_PUBLISH_2"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_PUBLISH_3.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_PUBLISH_3"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_PUBLISH_4.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_PUBLISH_4"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_TABLES.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_TABLES"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_CONTENT_ZXFT.ixf' OF IXF INSERT INTO "XXP"."ECMS_CONTENT_ZXFT"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_EXCHANGE_ITEM.ixf' OF IXF INSERT INTO "XXP"."ECMS_EXCHANGE_ITEM"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_EXCHANGE_LEAVE.ixf' OF IXF INSERT INTO "XXP"."ECMS_EXCHANGE_LEAVE"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_EXCHANGE_PRIV.ixf' OF IXF INSERT INTO "XXP"."ECMS_EXCHANGE_PRIV"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_EXCHANGE_PROCESS.ixf' OF IXF INSERT INTO "XXP"."ECMS_EXCHANGE_PROCESS"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_EXCHANGE_TYPE.ixf' OF IXF INSERT INTO "XXP"."ECMS_EXCHANGE_TYPE"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_FILES.ixf' OF IXF INSERT INTO "XXP"."ECMS_FILES"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_NODES.ixf' OF IXF INSERT INTO "XXP"."ECMS_NODES"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_NODE_SERIAL.ixf' OF IXF INSERT INTO "XXP"."ECMS_NODE_SERIAL"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_PRIV.ixf' OF IXF INSERT INTO "XXP"."ECMS_PRIV"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_PRIVILEGES.ixf' OF IXF INSERT INTO "XXP"."ECMS_PRIVILEGES"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_RELATED_DOC.ixf' OF IXF MODIFIED BY IDENTITYOVERRIDE INSERT INTO "XXP"."ECMS_RELATED_DOC"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_ROLE.ixf' OF IXF INSERT INTO "XXP"."ECMS_ROLE"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_SERIAL.ixf' OF IXF INSERT INTO "XXP"."ECMS_SERIAL"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_SITES.ixf' OF IXF INSERT INTO "XXP"."ECMS_SITES"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_TEMPLATE_NODE.ixf' OF IXF INSERT INTO "XXP"."ECMS_TEMPLATE_NODE"; LOAD CLIENT FROM 'E:\1\srsixf\ECMS_USER.ixf' OF IXF INSERT INTO "XXP"."ECMS_USER"; LOAD CLIENT FROM 'E:\1\srsixf\INFORMATION_1.ixf' OF IXF MODIFIED BY IDENTITYOVERRIDE INSERT INTO "XXP"."INFORMATION_1"; LOAD CLIENT FROM 'E:\1\srsixf\INFORMATION_2.ixf' OF IXF MODIFIED BY IDENTITYOVERRIDE INSERT INTO "XXP"."INFORMATION_2"; LOAD CLIENT FROM 'E:\1\srsixf\INFORMATION_3.ixf' OF IXF MODIFIED BY IDENTITYOVERRIDE INSERT INTO "XXP"."INFORMATION_3"; LOAD CLIENT FROM 'E:\1\srsixf\INFORMATION_4.ixf' OF IXF MODIFIED BY IDENTITYOVERRIDE INSERT INTO "XXP"."INFORMATION_4"; LOAD CLIENT FROM 'E:\1\srsixf\LOG.ixf' OF IXF INSERT INTO "XXP"."LOG"; LOAD CLIENT FROM 'E:\1\srsixf\LOGIN.ixf' OF IXF INSERT INTO "XXP"."LOGIN"; LOAD CLIENT FROM 'E:\1\srsixf\ORGAN.ixf' OF IXF INSERT INTO "XXP"."ORGAN"; LOAD CLIENT FROM 'E:\1\srsixf\SYN_NODE.ixf' OF IXF INSERT INTO "XXP"."SYN_NODE"; LOAD CLIENT FROM 'E:\1\srsixf\USER_NODE.ixf' OF IXF INSERT INTO "XXP"."USER_NODE"; LOAD CLIENT FROM 'E:\1\srsixf\USER_ORGAN.ixf' OF IXF INSERT INTO "XXP"."USER_ORGAN"; LOAD CLIENT FROM 'E:\1\srsixf\USER_PRIV.ixf' OF IXF INSERT INTO "XXP"."USER_PRIV"; LOAD CLIENT FROM 'E:\1\srsixf\USER_ROLE.ixf' OF IXF INSERT INTO "XXP"."USER_ROLE"; LOAD CLIENT FROM 'E:\1\srsixf\VOTE_ADMIN_REPLY.ixf' OF IXF INSERT INTO "XXP"."VOTE_ADMIN_REPLY"; LOAD CLIENT FROM 'E:\1\srsixf\VOTE_ITEM.ixf' OF IXF INSERT INTO "XXP"."VOTE_ITEM"; LOAD CLIENT FROM 'E:\1\srsixf\VOTE_OPTION.ixf' OF IXF INSERT INTO "XXP"."VOTE_OPTION"; LOAD CLIENT FROM 'E:\1\srsixf\VOTE_PRIV.ixf' OF IXF INSERT INTO "XXP"."VOTE_PRIV"; LOAD CLIENT FROM 'E:\1\srsixf\VOTE_REPLY.ixf' OF IXF INSERT INTO "XXP"."VOTE_REPLY"; LOAD CLIENT FROM 'E:\1\srsixf\VOTE_SUBJECT.ixf' OF IXF INSERT INTO "XXP"."VOTE_SUBJECT"; LOAD CLIENT FROM 'E:\1\srsixf\VOTE_TYPE.ixf' OF IXF INSERT INTO "XXP"."VOTE_TYPE"; LOAD CLIENT FROM 'E:\1\srsixf\VOTE_USERINFO.ixf' OF IXF INSERT INTO "XXP"."VOTE_USERINFO";
发表评论
-
JRebel
2016-06-02 10:14 5152. 单独使用JRebel.jar破解版(如在64位下WIND ... -
android
2016-05-10 14:53 269对于 LinearLayout 当 android:ori ... -
html 里的回车换行,制表符 引号,\ 等符号的转化
2014-06-22 17:17 1048/* * To change this license h ... -
netbeans插件
2013-12-10 22:42 372Text Popup Menu 在 Windows 7 ... -
ipv6
2013-11-24 20:23 460Window--Preferences--JAVA--Inst ... -
java编码转化
2013-11-09 16:46 546@Test public void test ... -
eclipse打开插件
2013-11-06 16:24 527openExplorer 一个eclipse小插件——打开当前 ... -
在Windows上与MySQL服务器的连接失败(大数据量) For Windows-based platforms, see Microsoft Knowle
2013-07-16 09:11 1210发生的异常: The driver was unable ... -
java 公用库
2013-03-13 10:24 776转载 本文主要介绍自己在开发过程中总结的一些Java工具类,主 ... -
InetAddress
2013-03-04 13:59 551String ip = ""; ... -
转文件编码格式
2012-06-19 19:55 867转@Test public void testConver ... -
myeclipse 9 property svn 插件
2011-10-07 18:04 12401、下载最新的SVN包(我下的是1.0.6版): http: ... -
lucene compass
2011-09-25 17:39 869PaodingAnalyzer analy ... -
spring 中的bean 大小写
2011-07-19 16:45 2352使用spring注释形式注入bean,通过@Component ... -
sooba xpdf lucene
2010-11-30 11:26 1127XPDF使用文档 XPDF版本 3.0.2 日期 2008 ... -
struts2
2010-09-17 11:48 592<s:if test="%{#session. ... -
编 码
2009-08-08 00:06 758Java中的ASCII,Unicode和UTF ... -
jBPM4.0中文文档.pdf
2009-07-23 10:16 1816jBPM4.0中文文档 -
Java中获取指定URL的输出
2009-07-21 19:38 1428import java.io.ByteArrayOutputS ... -
location.href 和session的问题
2009-05-21 18:52 1861一个页面有两个 iframe 在其中一个iframe页面内访问 ...
相关推荐
DB2学习资料以及常用命令的整理和总结!
DB2学习笔记DB2学习笔记DB2学习笔记
db2学习资料精选
DB2 学习教程全面整理打包
我自学db2的笔记,涉及日常的使用命令和db2表空间设定。
DB2学习文件 是公司中的实用学习资料,齐全,包你满意
DB2的建库建表命令,及基本的增删改查命令。
很好的db2 学习资料,讲述了db2数据库对象.
db2学习资料.rar
DB2游标、存储过程、类型与oracle的不同等
db2学习资料精选
DB2 V10 管理学习书籍,对于学习DB2很有帮助,供学习参考
DB2(数据库管理命令) DB2(数据操作命令) DB2学习笔记(TIPS) DB2学习笔记(管理工具的使用
DB2学习笔记.docxDB2学习笔记.docx
总结了db2学习笔记,其中重点总结了oracle、mysql、db2三种数据库的分页
DB2学习笔记
DB2学习总结文档word版,DB2初学者可以下载下来看看,参考作用!
db2学习资源(ppt课件),想学习使用db2的朋友可以下载下来看看。