http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2888]
PostgreSQL [103]
기타정보 [150]
운영체제 [577]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: DB2

 회원가입

test memo
최길호 [LIST]   2014-04-14 18:21:19, 조회 : 2,374

cd server
./db2_install
groupadd db2igrp
useradd -g db2igrp db2
groupadd db2fgrp
useradd -g db2fgrp db2f

cd /opt/ibm/db2/V9.7/instance
생성# ./db2icrt -u db2f db2
제거# ./db2idrop db2

# ps -ef | grep db2
root      8127     1  0 17:22 ?        00:00:00 /opt/ibm/db2/V9.7/bin/db2fmcd
cat /etc/inittab
# Run xdm in runlevel 5
x:5:respawn:/etc/X11/prefdm -nodaemon
fmc:2345:respawn:/opt/ibm/db2/V9.7/bin/db2fmcd #DB2 Fault Monitor Coordinator

db2sampl
db2 catalog db sample
db2 list db directory

db2 create db test on /data
find /data
/data
/data/db2
/data/db2/NODE0000
/data/db2/NODE0000/TEST
/data/db2/NODE0000/TEST/T0000001
/data/db2/NODE0000/TEST/T0000001/.SQLCRT.FLG
/data/db2/NODE0000/TEST/T0000001/C0000000.TMP
/data/db2/NODE0000/TEST/T0000001/C0000000.TMP/SQLTAG.NAM
/data/db2/NODE0000/TEST/.SQLCRT.FLG
/data/db2/NODE0000/TEST/T0000002
/data/db2/NODE0000/TEST/T0000002/.SQLCRT.FLG
/data/db2/NODE0000/TEST/T0000002/C0000000.LRG
/data/db2/NODE0000/TEST/T0000000
/data/db2/NODE0000/TEST/T0000000/C0000000.CAT
/data/db2/NODE0000/TEST/T0000000/.SQLCRT.FLG
/data/db2/NODE0000/SQL00001
/data/db2/NODE0000/SQL00001/SQLSGF.2
/data/db2/NODE0000/SQL00001/db2rhist.bak
/data/db2/NODE0000/SQL00001/SQLOGDIR
/data/db2/NODE0000/SQL00001/SQLOGDIR/S0000002.LOG
/data/db2/NODE0000/SQL00001/SQLOGDIR/S0000001.LOG
/data/db2/NODE0000/SQL00001/SQLOGDIR/S0000000.LOG
/data/db2/NODE0000/SQL00001/SQLTMPLK
/data/db2/NODE0000/SQL00001/SQLOGCTL.LFH.1
/data/db2/NODE0000/SQL00001/SQLOGCTL.LFH.2
/data/db2/NODE0000/SQL00001/SQLBP.1
/data/db2/NODE0000/SQL00001/SQLDBCONF
/data/db2/NODE0000/SQL00001/SQLSPCS.1
/data/db2/NODE0000/SQL00001/db2rhist.asc
/data/db2/NODE0000/SQL00001/SQLSPCS.2
/data/db2/NODE0000/SQL00001/SQLOGMIR.LFH
/data/db2/NODE0000/SQL00001/SQLSGF.1
/data/db2/NODE0000/SQL00001/SQLDBCON
/data/db2/NODE0000/SQL00001/db2event
/data/db2/NODE0000/SQL00001/db2event/db2detaildeadlock
/data/db2/NODE0000/SQL00001/db2event/db2detaildeadlock/00000000.evt
/data/db2/NODE0000/SQL00001/db2event/db2detaildeadlock/db2event.ctl
/data/db2/NODE0000/SQL00001/SQLBP.2
/data/db2/NODE0000/SQL00001/SQLINSLK
/data/db2/NODE0000/sqldbdir
/data/db2/NODE0000/sqldbdir/sqldbins
/data/db2/NODE0000/sqldbdir/sqldbdir
/data/db2/NODE0000/sqldbdir/sqldbbak


$ db2 list db directory

System Database Directory

Number of entries in the directory = 3

Database 1 entry:

Database alias                       = TEST
Database name                        = TEST
Local database directory             = /data
Database release level               = d.00
Comment                              =
Directory entry type                 = Indirect
Catalog database partition number    = 0
Alternate server hostname            =
Alternate server port number         =

Database 2 entry:

Database alias                       = SAMPLE
Database name                        = SAMPLE
Local database directory             = /home/db2
Database release level               = d.00
Comment                              =
Directory entry type                 = Indirect
Catalog database partition number    = 0
Alternate server hostname            =
Alternate server port number         =

Database 3 entry:

Database alias                       = MYDB
Database name                        = MYDB
Local database directory             = /db2
Database release level               = d.00
Comment                              =
Directory entry type                 = Indirect
Catalog database partition number    = 0
Alternate server hostname            =
Alternate server port number         =
3.235.78.122


  LIST

제목 작성자 작성일 조회
Install&Config  SQL30082N 이유 "42"("ROOT CAPABILITY REQUIRED")(으)로 인해 보안 처리에 실패했습니다.    최길호 2022/04/28 34
Troubleshoot  [jcc][t4][10205][11235][4.11.77] 널(NULL) password은(는) 지원되지 않습니다. ERRORCODE=-4461, SQLSTATE=42815    최길호 2020/10/24 497
Admin  DB2 상태 확인 status    최길호 2019/05/06 689
Admin  trigger test    최길호 2019/03/30 668
Admin  auto commit on/off    최길호 2019/03/30 932
Troubleshoot  DB21034E SQL0104N An unexpected token ";"/db2set DB2OPTIONS=-t/    최길호 2019/03/30 3744
Admin  dba_objects dba_tables    최길호 2019/03/26 685
Troubleshoot  sql trace / db2 login fail log    최길호 2019/03/22 846
Troubleshoot  SQL0332N Character conversion from the source code page "970" to the target code page "819" is not supported.    최길호 2019/02/22 825
Admin  db2 list application [ db2 session 정보 확인 ]    최길호 2019/02/09 692
Backup&Recovery  test    최길호 2019/02/05 1013
Troubleshoot  SQL6031N Error in the db2nodes.cfg file at line number "1". Reason code "10". [ hostname 변경 ]    최길호 2019/02/03 1193
Backup&Recovery  SQL1116N SQL2413N [ db2dart test /CHST /WHAT DBBP OFF ]    최길호 2014/04/22 4103
Troubleshoot  SQL0204N "DB2.TAB" is an undefined name. SQLSTATE=42704    최길호 2014/04/15 2908
Admin  db2 catalog tcpip node [ listener.ora, tnsnames.ora ]    최길호 2014/04/15 2079
Admin  test memo    최길호 2014/04/14 2374

    목록보기   다음페이지 1 [2][3][4]
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by 최길호
06/25
[ORACLE]
Replication may not be valid i....
by 최길호
06/22
[운영체제]
CentOS7 홈페이지 Migration 메모.
by 최길호