From YiPs Wiki (i powered)

XMLSERVICE: PHPDB 2 Attr

Goto Main Page
Goto PHP page
Goto Documents

------------------------
Extended options ibm_db2.ini
------------------------
etc/config.d/ibm_db2.ini
extension=ibm_db2.so

; Commitment control
;   0 - DB2_I5_TXN_NO_COMMIT (0=no commit, works CRTLIB no journal containers)
;   1 - enable default commit setting (DB2 default)
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : do not use
; program override
;   array('i5_commit'=>DB2_I5_TXN_NO_COMMIT, ...)
ibm_db2.i5_allow_commit=1

; *NEW force PASE CCSID (utf-8 1208)
;   0 - default PASE CCSID
;   1208 - force utf-8 PASE CCSID (better DB2 operations)
;   n - other PASE CCSIDS possible (not tested)
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : do not use
; program override
;   none
ibm_db2.i5_override_ccsid=1208

; *NEW System naming mode (also work LUW Db2 Conect V10.5)
;   0 - default SQL naming (schema.table ... libl ignored)
;   1 - IBM i system naming (lib/file ...  libl / curlib works)
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : enabled
; program override
;   array('i5_naming'=>DB2_I5_NAMING_OFF,'i5_lib'=>'MYLIB')  -- not valid LUW (use "set schema")
;   array('i5_naming'=>DB2_I5_NAMING_OFF), then @db2_exec('set schema MYLIB')
;   array('i5_naming'=>DB2_I5_NAMING_ON,'i5_libl'=>'QTEMP MYLIB','i5_curlib'=>'MYLIB')
ibm_db2.i5_sys_naming=0

; *NEW start server mode jobs to subsystem (QSQ jobs)
;   > crtlib adc                                     
;   > CRTSBSD SBSD(ADC/ADC) POOLS((1 *BASE)) TEXT('tony subsystem descr')
;   > CRTJOBD JOBD(ADC/ADC) TEXT('tony job descr')   
;   > CRTCLS CLS(ADC/ADC) TEXT('tony class')              
;   > ADDPJE SBSD(ADC/ADC) PGM(QSYS/QSQSRVR) MAXJOBS(*NOMAX)
;   > strsbs adc/adc
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : do not use
; program override
;   array('i5_subsystem' => 'adc')
ibm_db2.i5_servermode_subsystem=ADC

; *NEW Advanced db2_pconnect monitor (DB2 pconnect maid service, 1-4 tests)
;   4 - try conn new statement (check statement) 
;   3 - try allocate new statement (check allocate)
;   2 - try conn get info (check meta data)
;   1 - try conn get an attribute (check attribute)
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : do not use
; program override
;   none
ibm_db2.i5_check_pconnect=1

; *NEW Job profile sort order
;   0 - default DB2 sort order
;   1 - job sort order
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : do not use
; program override
;   array('i5_job_sort'=>DB2_I5_JOB_SORT_ON,DB2_I5_JOB_SORT_OFF)
ibm_db2.i5_job_sort=0

; Ignore userid/password db2_connect(null) (no QSQ jobs if exclusive use)
;   0 - default QSQSRVR jobs matching db2_connect(db,user,password)
;   1 - force db2_connect(db,null,null), if site wide exclusive, no QSQSRVR jobs
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : do not use
; program override
;   none
ibm_db2.i5_ignore_userid=0

; DBCS extended 6x memory allocations conversions
;   0 - default allocations
;   1 - 6x allocations for larger ascii<>ebcdic character conversions
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : enabled
; program override
;   array('i5_dbcs_alloc'=>DB2_I5_DBCS_ALLOC_ON)
ibm_db2.i5_dbcs_alloc=0

; Force db2_connect to db2_pconnect (no change script)
;   0 - default script db2_connect 
;   1 - override db2_connect to db2_pconnect
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : enabled
; program override
;   none
ibm_db2.i5_all_pconnect=0

; *NEW Max use count db2_pconnect to recycle
;   0 - default db2_pconnect unlimited use persistent connection
;   n - recycle db2_pconnect persistent connection at count usage
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : do not use
; program override
;   none
ibm_db2.i5_max_pconnect=0

; *NEW Allow blank userid/password (security change over prior releases)
;   0 - default restrict blank userid/password 
;       enforcing IBM i latest PTF policy no blank passwords
;   1 - allow blank userid/password
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : do not use
; program override
;   none
ibm_db2.i5_blank_userid=1

; *NEW DB2 error log verbose (SQL errors var/logs/php.log)
;   0 - default log behavior original design (production)
;   1 - additional log information, SQL errors, etc (debug)
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : enabled
; program override
;   none
ibm_db2.i5_log_verbose=0

; *NEW Guard profile (switch back profile xmlservice clients)
;   0 - default no monitor of QSQSRVR job profile active
;   1 - monitor QSQSRVR job profile, return to original if changed
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : enabled
; program override
;   none
ibm_db2.i5_guard_profile=1

; *NEW XMLSERVICE install library (use with guard profile)
;   library - install library of XMSLERVICE
;             for use with i5_guard_profile
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : enabled
; program override
;   none
ibm_db2.i5_xmlservice_install=ZENDSVR

; *NEW workaround attribute conversion (PASE libdb400.a bug)
;   0 - default workaround enabled 
;   1 - workaround no longer needed
; Following attributes not work (unless PASE 1208 CCSID), 
; libdb400.a will require a PTF to fix, workaround use i5_db400_ptf=0
; (default if missing)
;   SQL_ATTR_SERVERMODE_SUBSYSTEM   array('i5_subsystem' => 'adc')
;   SQL_ATTR_INFO_USERID            array('userid' => 'db2inst1');
;   SQL_ATTR_INFO_ACCTSTR           array('acctstr' => 'account')
;   SQL_ATTR_INFO_APPLNAME          array('applname' => 'myapp')
;   SQL_ATTR_INFO_WRKSTNNAME        array('wrkstnname' => 'workstation')
; platforms
;   IBM i (PASE): enabled
;   LUW-2-IBM i : do not use
; program override
;   none
ibm_db2.i5_db400_ptf=0

------------------------
Extended program attributes
(most i5 attributes also available LUW-2-IBMi 10.5+)
------------------------
'i5_commit'  => DB2_I5_TXN_NO_COMMIT        - Commitment control is not used.
                DB2_I5_TXN_READ_UNCOMMITTED - Dirty reads, nonrepeatable reads, and phantoms are possible. 
                DB2_I5_TXN_READ_COMMITTED   - Dirty reads are not possible. Nonrepeatable reads, and phantoms are possible. 
                DB2_I5_TXN_REPEATABLE_READ  - Dirty reads and nonrepeatable reads are not possible. Phantoms are possible. 
                DB2_I5_TXN_SERIALIZABLE     - Transactions are serializable. Dirty reads, non-repeatable reads, 
                                              and phantoms are not possible
'i5_naming'        => DB2_I5_NAMING_OFF     - value turns off DB2 UDB CLI default naming mode, which is SQL naming. (default)
                                              Files are qualified using the period (.) delimiter. 
                                              Unqualified files are resolved using 
                                              either the default library or the current user ID.
'i5_lib'           => 'MYLIB'               - used with DB2_I5_NAMING_OFF (not LUW, use "set schema mylib")
'i5_naming'        => DB2_I5_NAMING_ON      - value turns on DB2 UDB CLI iSeries system naming mode. 
                                              Files are qualified using the slash (/ or .) delimiter. 
                                              Unqualified files are resolved using the library list for the job.
'i5_libl'          => 'QTEMP MYLIB'         - used with DB2_I5_NAMING_ON
'i5_curlib'        => 'MYLIB'               - used with DB2_I5_NAMING_ON
'i5_job_sort'      => DB2_I5_JOB_SORT_OFF   - value turns on DB2 UDB CLI job sort mode (default)
                      DB2_I5_JOB_SORT_ON    - value turns on DB2 UDB CLI job sort mode
'i5_dbcs_alloc'    => DB2_I5_DBCS_ALLOC_ON  - value turns on DB2 6X allocation scheme for DBCS translation column size growth.
		                  DB2_I5_DBCS_ALLOC_OFF - value turns off DB2 6X allocation scheme for DBCS translation column size growth.
'i5_date_fmt'      => DB2_I5_FMT_ISO        - (ISO) date format yyyy-mm-dd is used. This is the default. 
                      DB2_I5_FMT_USA        - The United States date format mm/dd/yyyy is used. 
                      DB2_I5_FMT_EUR        - The European date format dd.mm.yyyy is used. 
                      DB2_I5_FMT_JIS        - The Japanese Industrial Standard date format yyyy-mm-dd is used. 
                      DB2_I5_FMT_MDY        - The date format mm/dd/yyyy is used. 
                      DB2_I5_FMT_DMY        - The date format dd/mm/yyyy is used. 
                      DB2_I5_FMT_YMD        - The date format yy/mm/dd is used. 
                      DB2_I5_FMT_JUL        - The Julian date format yy/ddd is used. 
                      DB2_I5_FMT_JOB        - The job default is used.
'i5_date_sep'      => DB2_I5_SEP_SLASH      - A slash ( / ) is used as the date separator. This is the default. 
                      DB2_I5_SEP_DASH       - A dash ( - ) is used as the date separator. 
                      DB2_I5_SEP_PERIOD     - A period ( . ) is used as the date separator. 
                      DB2_I5_SEP_COMMA      - A comma ( , ) is used as the date separator. 
                      DB2_I5_SEP_BLANK      - A blank is used as the date separator. 
                      DB2_I5_SEP_JOB        - The job default is used
'i5_time_fmt'      => DB2_I5_FMT_ISO        - (ISO) time format hh.mm.ss is used. This is the default. 
                      DB2_I5_FMT_USA        - The United States time format hh:mmxx is used, where xx is AM or PM. 
                      DB2_I5_FMT_EUR        - The European time format hh.mm.ss is used. 
                      DB2_I5_FMT_JIS        - The Japanese Industrial Standard time format hh:mm:ss is used. 
                      DB2_I5_FMT_HMS        - The hh:mm:ss format is used.
'i5_time_sep'      => DB2_I5_SEP_COLON      - A colon ( : ) is used as the time separator. This is the default. 
                      DB2_I5_SEP_PERIOD     - A period ( . ) is used as the time separator. 
                      DB2_I5_SEP_COMMA      - A comma ( , ) is used as the time separator. 
                      DB2_I5_SEP_BLANK      - A blank is used as the time separator. 
                      DB2_I5_SEP_JOB        - The job default is used.
'i5_decimal_sep'   => DB2_I5_SEP_PERIOD     - A period ( . ) is used as the decimal separator. This is the default. 
                      DB2_I5_SEP_COMMA      - A comma ( , ) is used as the date separator. 
                      DB2_I5_SEP_JOB        - The job default is used.
'i5_subsystem'     => 'adc'                 - IBM i subsystem for QSQSRVR jobs
                                              > crtlib adc                                     
                                              > CRTSBSD SBSD(ADC/ADC) POOLS((1 *BASE)) TEXT('tony subsystem descr')
                                              > CRTJOBD JOBD(ADC/ADC) TEXT('tony job descr')   
                                              > CRTCLS CLS(ADC/ADC) TEXT('tony class')              
                                              > ADDPJE SBSD(ADC/ADC) PGM(QSYS/QSQSRVR) MAXJOBS(*NOMAX)
                                              > strsbs adc/adc
'i5_query_optimize'=> DB2_ALL_IO            - All queries are optimized with the goal of running the 
                                              entire query to completion in the shortest amount of 
                                              elapsed time. (default)
                      DB2_FIRST_IO          - All queries are optimized with the goal of returning the first page 
                                              of output as fast as possible.
'i5_fetch_only'    => DB2_I5_FETCH_ON       - Cursors are read-only and cannot be used for 
                                              positioned updates or deletes.
                      DB2_I5_FETCH_OFF      - Cursors can be used for positioned updates and deletes.

'autocommit'       => DB2_AUTOCOMMIT_ON     - transaction commit immediate
                      DB2_AUTOCOMMIT_OFF    - transaction commit user controlled commit/rollback
'userid'           => 'db2inst1'
'acctstr'          => 'account'
'applname'         => 'myapp'
'wrkstnname'       => 'workstation'
'cursor'           => DB2_SCROLLABLE
                      DB2_FORWARD_ONLY
'binmode'          => (not available IBM i)
'db2_attr_case'    => (not available IBM i)
'rowcount'         => (not available IBM i)
'trustedcontext'   => (not available IBM i)
'trusted_user'     => (not available IBM i)
'trusted_password' => (not available IBM i)
'query_timeout'    => (not available IBM i)
'deferred_prepare' => (not available IBM i)

Retrieved from http://youngiprofessionals.com/wiki/index.php/XMLSERVICE/PHPDB2Attr
Page last modified on June 04, 2014, at 03:18 PM EST