IOTN :: Field Book :: DB2

ȸ¿ø°¡ÀÔ

auto commit on/off

ÃÖ±æÈ£ [LIST]   2019-03-30 22:03:38, Á¶È¸ : 931 default Auto-Commit : ON $  db2 list command options | egrep 'Auto-Commit|DB2OPTIONS' Command options                           (DB2OPTIONS) =    -c    Auto-Commit                               ON $ db2set DB2OPTIONS=+c $ db2 list command options | egrep 'Auto-Commit|DB2OPTIONS' Command options                           (DB2OPTIONS) = +c    -c    Auto-Commit                               OFF $ db2set DB2OPTIONS=     $ db2 list command options | egrep 'Auto-Commit|DB2OPTIONS' Command options                           (DB2OPTIONS) =    -c    Auto-Commit                               ON $ db2 db2 => LIST COMMAND OPTIONS      Command Line Processor Option Settings Backend process wait time (seconds)        (DB2BQTIME) = 1 No. of retries to connect to backend        (DB2BQTRY) = 60 Request queue wait time (seconds)          (DB2RQTIME) = 5 Input queue wait time (seconds)            (DB2IQTIME) = 5 Command options                           (DB2OPTIONS) = Option  Description                               Current Setting ------  ----------------------------------------  ---------------    -a    Display SQLCA                             OFF    -c    Auto-Commit                               ON  <<<<<<<<<<< [ current session Auto-Commit OFF ] db2 => UPDATE COMMAND OPTIONS USING c OFF DB20000I  The UPDATE COMMAND OPTIONS command completed successfully. or $ db2 -c db2 => LIST COMMAND OPTIONS      Command Line Processor Option Settings Backend process wait time (seconds)        (DB2BQTIME) = 1 No. of retries to connect to backend        (DB2BQTRY) = 60 Request queue wait time (seconds)          (DB2RQTIME) = 5 Input queue wait time (seconds)            (DB2IQTIME) = 5 Command options                           (DB2OPTIONS) = Option  Description                               Current Setting ------  ----------------------------------------  ---------------    -a    Display SQLCA                             OFF    -c    Auto-Commit                               OFF <<<<<<<<<<<    -d    Retrieve and display XML declarations     OFF    -e    Display SQLCODE/SQLSTATE                  OFF    -f    Read from input file                      OFF    -i    Display XML data with indentation         OFF    -l    Log commands in history file              OFF    -m    Display the number of rows affected       OFF    -n    Remove new line character                 OFF    -o    Display output                            ON    -p    Display interactive input prompt          ON    -q    Preserve whitespaces & linefeeds          OFF    -r    Save output to report file                OFF    -s    Stop execution on command error           OFF    -t    Set statement termination character       OFF    -v    Echo current command                      OFF    -w    Display FETCH/SELECT warning messages     ON    -x    Suppress printing of column headings      OFF    -z    Save all output to output file            OFF db2 => Ãâó: http://www.talkwithtrend.com/Article/185045 https://stackoverflow.com/questions/25494089/db2-sql-script-how-to-start-a-transaction-and-rollback-on-error 3.235.78.122

LIST

CategoryInstall&ConfigBackup&RecoveryTuningTroubleshootScriptAdmin	Á¦¸ñ	ÀÛ¼ºÀÚ	ÀÛ¼ºÀÏ	Á¶È¸
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	931
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	845
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	691
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)