in0de

db2Dean’s Favorite Links
아주 일목요연한 db2 link 모음
http://www.db2dean.com/Previous/DeanLinks.html

developerWorks: 다운로드
http://www.ibm.com/developerworks/kr/downloads/

IBM FixCentral
다운로드 하기 좋게 리뉴얼 됨
http://www-933.ibm.com/support/fixcentral/

Fix Packs for IBM DB2 and IMS Tools - DB2RE, PE, HPU
http://www-01.ibm.com/support/docview.wss?rs=434&uid=swg27008647

DMMag
이제 온라인으로 발간함
http://www.ibmdmmagazinedigital.com

IDUG
http://www.idug.org/

KDUG
나름 활성화 된 IBM 주도 DB2 커뮤니티
http://www.kdug.kr/

SQL limits
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0001029.htm

SQL and XML limits
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.ref.doc/doc/r0001029.html

IBM Redbooks
필독서들. 읽을 시간은 있을 지?
http://www.redbooks.ibm.com/

IBM DB2 for Linux, Unix, and Windows Forum
http://www.ibm.com/developerworks/forums/forum.jspa?forumID=842&cat=19

Information Management Training : Self-Study Courses
http://www-01.ibm.com/software/data/education/selfstudy.html

DB2 Podcast series on channelDb2
http://www-01.ibm.com/software/sw-library/en_US/detail/R910330G45195P41.html

DB2 LUW DBA HowTo - Useful database administration techniques for Unix (LUW/UDB) DB2
http://www.ebenner.com/db2dba_blog/

developersWork search
사실, 찾아도 잘 안찾아지는 IBM의 검색 페이지.
http://www.ibm.com/developerworks/search/searchResults.jsp?searchType=1&searchSite=dW&searchScope=dW&query=&Search.x=28&Search.y=10&Search=Search

Everything You Wanted to Know About DB2 Universal Database Processes
http://www.ibm.com/developerworks/data/library/techarticle/0304chong/0304chong.html

IBM - DB2 사용자 게시판
한국 IBM이 관리하는. 어떻게 하면 이렇게 망할 수 있는 지?
http://www-903.ibm.com/kr/bbs/board_list.jsp?bbs=6

IBM - DB2 기술 정보
한국 IBM이 관리하는. 어떻게 하면 이렇게 업데이트가 없을 수 있는 지?
http://www-903.ibm.com/kr/techinfo/db2/

Migrating Recursive SQL from Oracle to DB2 UDB
http://www.ibm.com/developerworks/data/library/techarticle/0307steinbach/0307steinbach.html

Bringing the Power of Regular Expression Matching to SQL
http://www.ibm.com/developerworks/data/library/techarticle/0301stolze/0301stolze.html

Essential Facts about Index Covering in DB2 Universal Database
http://www.ibm.com/developerworks/data/library/techarticle/0303kuznetsov/0303kuznetsov.html

Improve DB2 query performance in a business intelligence environment - 튜닝 기술
http://www.ibm.com/developerworks/data/library/techarticle/dm-0703kapoor/

데이터 유형 간 캐스팅
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.ref.doc/doc/r0008478.html

Lock events for DB2 for Linux, UNIX, and Windows, Part 1: Analyzing lockwait situations in DB2 for Linux, UNIX, and Windows
http://www.ibm.com/developerworks/data/library/techarticle/dm-0707fechner/index.html

Influence query optimization with optimization profiles and statistical views in DB2 9
http://www.ibm.com/developerworks/data/library/techarticle/dm-0612chen/

Making DB2 Case-Insensitive
http://www.ibm.com/developerworks/data/library/techarticle/0203adamache/0203adamache.html

dBforums - DB2
활발한 QnA, 문제를 검색하면 답변을 여기서 자주 얻기도 함
http://www.dbforums.com/db2/

DB2 SQL Cookbook Downloads Page
http://mysite.verizon.net/Graeme_Birchall/id1.html

An Expert's Guide to DB2 Technology
활발히 활동하는 블로거
http://it.toolbox.com/blogs/db2luw

Planet DB2
db2 blogger들의 메타 블로그
http://planetdb2.com/

Database Journal - DB2 Featured Database Articles
저널 형식의 짧은 특집, 기술 동향, 특집 컬럼
http://www.databasejournal.com/features/db2/

DBsarang - db2
http://database.sarang.net/?criteria=db2

DB2PORTAL Blog
http://db2portal.blogspot.com/

DB2uter
앞서가는 정보
http://www.ibmsystemsmag.blogs.com/db2utor/

깜장별 블로그
아마 엑셈에 근무하시는 db2 엔지니어이신 듯
http://bstar36.tistory.com/category/DB2

DB2ude
기술적인 내용을 다루는 블로그. 여기서도 해결책을 종종 찾을 수 있음.
http://www.db2ude.com/

추천 도서 리스트: Linux, UNIX, Windows용 DB2 UDB (한글)
쪼끔 오래되었으나 기본적인 내용들이기 때문에 언제 보아도 도움이 됨
http://www.ibm.com/developerworks/kr/library/dm-0509poon2/index.html

한국 데이터베이스 진흥원
이 조직이 정말 DB를 진흥해 주고 있는가?!
http://www.dpc.or.kr/

The Connection String Reference
DB Driver 연결 설정 스트링 참조 총망라
http://www.connectionstrings.com/

IBM Professional Certification Program
IBM 자격 시험 등록 페이지
https://www-903.ibm.com/kr/education/certify/index.html

IBM - IBM 자격증 로드맵
http://www-304.ibm.com/jct03001c/services/learning/ites.wss/kr/ko?pageType=page&c=a0013990

숭실대학교 Database lab
이상호 교수가 이끄는 팀. 2006년부터 DB2를 위주로 함
http://dblab.ssu.ac.kr/overview.html

DeveloperWorks - Best practices for DB2 for Linux, UNIX, and Windows
말이 필요 없는 Best Practices
http://www.ibm.com/developerworks/data/bestpractices/?S_TACT=105AGX11&S_CMP=LP

Bootcamps and Education
가고는 싶지만, 갈 수 없는...
http://www.ibm.com/developerworks/data/bootcamps

Instant SQL Formatter
SQL을 보기 좋게 만들어주는 온라인 툴. 상세한 설정은 없음.
http://www.dpriver.com/pp/sqlformat.htm

EXPORT command & File type modifiers for the export utility.
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.cmd.doc/doc/r0008303.html

DB2 packages: Concepts, examples, and common problems
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606chun/index.html

DB2 기초: 제약조건 (한글)
http://www.ibm.com/developerworks/kr/library/dm-0401melnyk/index.html

DB2 기초: 재미있는 날짜와 시간
의외로 자주 참조하게 됨
http://www.ibm.com/developerworks/kr/library/dm-0401melnyk/index.html

DB2 API
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.apdv.api.doc/doc/r0001915.html

DB2 9.5로 고가용성 구현하기
http://www.ibm.com/developerworks/kr/library/dm-0807wright/

DB2 UDB performance tuning scenarios: Part 1, DB2 UDB OLTP tuning illustrated with a Java program
http://www.ibm.com/developerworks/data/library/techarticle/dm-0508chong/

How multithreaded architecture works in DB2 9.5
http://www.ibm.com/developerworks/data/library/techarticle/dm-0807kharche/

Quest - Toad for DB2
토드 상용 버전의 홈페이지
http://www.quest.com/db2-on-luw/

토드 기간 한정 베타버전을 여기서 미리미리 구해서 쓸 수 있음
http://toadfordb2.com/index.jspa

DB2Monitor
아주 작은 db2top 대응 윈도우용 모니터링 툴
http://chuzhoi_files.tripod.com/

처음 db2를 배우면 db2icrt, db2idrop과 함께 기본적으로 나오는 명령어이기는 하지만,
대체 언제 이것을 써먹을 수 있을까 대충 지나쳤던 부분인데, 실제로 적용할 일이 발생했다.

32bit WAS와 bit를 맞춰야 하는데 db2를 64bit로 설치했던 것.
그래서 -w 32 옵션으로 db2iupdt로 해결 가능했다.

db2iupdt -w 32 ${instanceName}