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

 회원가입

SQL1116N SQL2413N [ db2dart test /CHST /WHAT DBBP OFF ]
최길호 [LIST]   2014-04-22 10:43:30, 조회 : 4,102

[db2svr~]$ db2 backup db test to /data/backup/ compress

Backup successful. The timestamp for this backup image is : 20140422102352

noarchive mode 변경
[db2svr~]$ db2 UPDATE db cfg for test USING LOGARCHMETH1 off
db2 update db cfg for test using logretain off
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.

noarchive mode online 백업 시도 에러 확인
[db2svr~]$ db2 backup db test online to /data/backup/ compress
SQL2413N  Online backup is not allowed because the database is not recoverable
or a backup pending condition is in effect.

archvielog mode 변경
[db2svr~]$ db2 UPDATE db cfg for test USING LOGARCHMETH1 DISK:/data/arch IMMEDIATE
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.

online 백업 시도 에러
# 순서상 offline full 백업 해야함. db2 backup db test to /data/backup/ compress ]
# offline 백업 없이 진행 test
[db2svr~]$ db2 backup db test online to /data/backup/ compress
SQL2413N  Online backup is not allowed because the database is not recoverable
or a backup pending condition is in effect.

연결 시도 에러
[db2svr~]$ db2 connect to test
SQL1116N  A connection to or activation of database "TEST" cannot be made
because of BACKUP PENDING.  SQLSTATE=57019

SQL1116N  조치
[db2svr~]$ db2dart test /CHST /WHAT DBBP OFF

    Updated the log file header control file.
         The requested DB2DART processing has completed successfully!
                        Complete DB2DART report found in:
/home/db2/sqllib/db2dump/DART0000/TEST.RPT


연결 시도 정상
[db2svr~]$ db2 connect to test

   Database Connection Information

Database server        = DB2/LINUX 9.7.7
SQL authorization ID   = DB2
Local database alias   = TEST

online 백업 정상
[db2svr~]$ db2 backup db test online to /data/backup/ compress

Backup successful. The timestamp for this backup image is : 20140422102837

[db2svr~]$

출처: http://db2helmet.tistory.com/120
3.235.78.122


  LIST

제목 작성자 작성일 조회
Install&Config  SQL30082N 이유 "42"("ROOT CAPABILITY REQUIRED")(으)로 인해 보안 처리에 실패했습니다.    최길호 2022/04/28 33
Troubleshoot  [jcc][t4][10205][11235][4.11.77] 널(NULL) password은(는) 지원되지 않습니다. ERRORCODE=-4461, SQLSTATE=42815    최길호 2020/10/24 496
Admin  DB2 상태 확인 status    최길호 2019/05/06 688
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 3743
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 1012
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 4102
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 2078
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 최길호