Could not check DB2 registry settings

[former_member631284]

Dear all,

after a dbcopy in DB2/win environment I got the message error

Could not check DB2 registry settings.

Hereby the r3trans log

4 ETW000 R3trans was called as follows: r3trans -d -w f:\usr\sap\trans\newconfig.txt
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Fri Sep 20 18:13:43 2019 116 0.000116
4 ETW000 [ dev trc,00000] db_con_init called 70 0.000186
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)
4 ETW000 136 0.000322
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 17 0.000339
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 8 0.000347
4 ETW000 [ dev trc,00000] Loading DB library 'dbdb6slib.dll' ... 26 0.000373
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbdb6slib.dll"), hdl 0, addr 00007FFBECFD0000
4 ETW000 475 0.000848
4 ETW000 [ dev trc,00000] using "F:\usr\sap\TST\SYS\exe\uc\NTAMD64\dbdb6slib.dll" 16 0.000864
4 ETW000 [ dev trc,00000] Library 'dbdb6slib.dll' loaded 21 0.000885
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbdb6slib.dll 20 0.000905
4 ETW000 [ dev trc,00000] Version of 'dbdb6slib.dll' is "721.02", patchlevel (0.220) 140 0.001045
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbdb6slib.dll 27 0.001072
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbdb6slib.dll 23 0.001095
4 ETW000 [ dev trc,00000] New connection 0 created 27 0.001122
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 25 0.001147
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 29 0.001176
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 16 0.001192
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 10 0.001202
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 21 0.001223
4 ETW000 [ dev trc,00000] DB6 (DB2 UDB) UNICODE database interface 721.02 [opt] 1140 0.002363
4 ETW000 [ dev trc,00000] DB6 shared library (dbdb6slib) patchlevels 22 0.002385
4 ETW000 [ dev trc,00000] (0.6) DB6: isolation RS for select in INDX type cluster tables (note 1678935)
4 ETW000 21 0.002406
4 ETW000 [ dev trc,00000] (0.11) DB6: Global Compression Option (note 1690077) 23 0.002429
4 ETW000 [ dev trc,00000] (0.18) DB6: suppress location for internal SQL statements (note 1736676)
4 ETW000 66 0.002495
4 ETW000 [ dev trc,00000] (0.21) DB6: reload connect passwords for table materialization (note 1746047)
4 ETW000 18 0.002513
4 ETW000 [ dev trc,00000] (0.22) DB6: DBSL trace enhancements (note 31707) 11 0.002524
4 ETW000 [ dev trc,00000] (0.24) DB6: patch for DB6_DBSL_CLP_COMMAND (note 1755738) 12 0.002536
4 ETW000 [ dev trc,00000] (0.27) DB6: enhanced micro outage feature (note 1434153) 12 0.002548
4 ETW000 [ dev trc,00000] (0.32) DB6: patch collection 11/12 (note 1780383) 11 0.002559
4 ETW000 [ dev trc,00000] (0.39) DB6: patch collection 12/12 (note 1801754) 13 0.002572
4 ETW000 [ dev trc,00000] (0.44) DB6: Optimizer Profiles (note 1818503) 12 0.002584
4 ETW000 [ dev trc,00000] (0.112) DB6: Fetching NUMC NULL values into shorter output area (note 1835350)
4 ETW000 15 0.002599
4 ETW000 [ dev trc,00000] (0.119) DB6: patch collection 05/13 (note 1859667) 13 0.002612
4 ETW000 [ dev trc,00000] (0.123) DB6: SYSTEM_CORE_DUMPED in dsql_db6_fetch (note 1870680) 22 0.002634
4 ETW000 [ dev trc,00000] (0.126) DB6: trace flush of cumulative trace at deactivation time (note 1880502)
4 ETW000 16 0.002650
4 ETW000 [ dev trc,00000] (0.127) DB6: reconnect refused in batch work process (note 1884759)
4 ETW000 15 0.002665
4 ETW000 [ dev trc,00000] (0.131) DB6: messages related to SQL_ATTR_DB2TRC_STARTUP_SIZE (note 1836451)
4 ETW000 15 0.002680
4 ETW000 [ dev trc,00000] (0.137) DB6: DROP INDEX to DROP CONSTRAINT (note 1911087) 11 0.002691
4 ETW000 [ dev trc,00000] (0.210) DB6: long running SQL for revalidation (note 1925706) 12 0.002703
4 ETW000 [ dev trc,00000] (0.210) IBM i: Native SQL Array INSERT (note 1844270) 9 0.002712
4 ETW000 [ dev trc,00000] (0.210) ST04 overview screen is blocked (note 1921504) 10 0.002722
4 ETW000 [ dev trc,00000] (0.211) DB6: Micro outage lazy reconnect (note 1434153) 11 0.002733
4 ETW000 [ dev trc,00000] (0.214) SQL code even in case of failure to DS function (ADBC) (note 1958605)
4 ETW000 15 0.002748
4 ETW000 [ dev trc,00000] (0.220) DB6: FOR ALL ENTRIES using remote connection (note 1973869)
4 ETW000 12 0.002760
4 ETW000 [ dev trc,00000] Supported features: 8 0.002768
4 ETW000 [ dev trc,00000] ..retrieving configuration parameters 9 0.002777
4 ETW000 [ dev trc,00000] ..done 328 0.003105
4 ETW000 [ dev trc,00000] DB2 library has been loaded. 210187 0.213292
4 ETW000 [ dev trc,00000] Info: successfully loaded DB2 library '\\hostname\sapmnt\TST\SYS\global\db6\WINDOWS_AMD64\db6_clidriver\bin\db2app64.dll'
4 ETW000 59 0.213351
4 ETW000 [ dev trc,00000] Running with UTF-8 Unicode 82 0.213433
4 ETW000 [ dev trc,00000] DB2 client driver version '10.01.0005' 140979 0.354412
4 ETW000 [ dev trc,00000] Running with CLI driver. 24662 0.379074
4 ETW000 [ dev trc,00000] Fri Sep 20 18:13:44 2019 380999 0.760073
4 ETW000 [ dev trc,00000] Connected to DB server type 'DB2/NT64' 23 0.760096
4 ETW000 [ dev trc,00000] Connected to DB server version '10.01.0005' 28 0.760124
4 ETW000 [ dev trc,00000] Connected to 'TST' as 'SAPTST' schema 'SAPTST' o.k. 6947 0.767071
4 ETW000 [ dev trc,00000] Connected: con_hdl=0 ; appl_hdl=100; appl_id="fe80::b967:2ee7:c8:61dd%12.60759.190920161344"
4 ETW000 36 0.767107
4 ETW000 [ dev trc,00000] Current member="fe80::b967:2ee7:c8:61dd%12:5912" 15 0.767122
4 ETW000 [ dev trc,00000] Database code page is ok. 25 0.767147
4 ETW000 [ dev trc,00000] Database collating sequence is ok. 15305 0.782452
4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 14932] CON = 0 (BEGIN) 6921 0.789373
4 ETW000 [ dev trc,00000] &+ DbSlConnectDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0551N "SAPTST" does not have the required au
4 ETW000 35 0.789408
4 ETW000 [ dev trc,00000] &+ thorization or privilege to perform operation "EXECUTE" on object "SYSPROC.ENV_GET_REG_VARIABLES". SQLSTATE=42501
4 ETW000 24 0.789432
4 ETW000 [ dev trc,00000] &+
4 ETW000 22 0.789454
4 ETW000 [ dev trc,00000] &+
4 ETW000 21 0.789475
4 ETW000 [ dev trc,00000] &+ SELECT COUNT(*) FROM TABLE( ENV_GET_REG_VARIABLES( -1 ) ) WHERE REG_VAR_NAME = 'DB2_WORKLOAD' AND UPPER( REG_VAR_V
4 ETW000 23 0.789498
4 ETW000 [ dev trc,00000] &+ ALUE ) = 'SAP'
4 ETW000 20 0.789518
4 ETW000 [ dev trc,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=40, read_only=0
4 ETW000 25 0.789543
4 ETW000 [ dev trc,00000] &+
4 ETW000 27 0.789570
4 ETW000 [ dev trc,00000] &+
4 ETW000 22 0.789592
4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 14932] (END) 19 0.789611
4 ETW000 [ dev trc,00000] Could not check DB2 registry settings. 248 0.789859
4 ETW000 [ dev trc,00000] Disconnected from 'TST' 1637 0.791496
4 ETW000 [ dev trc,00000] Disconnected: con_hdl=0 ; appl_hdl=100; appl_id="fe80::b967:2ee7:c8:61dd%12.60759.190920161344"
4 ETW000 21 0.791517
4 ETW000 [ dev trc,00000] Environment Handle has been released. sql_rc=0 334 0.791851
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'TST'"

Could you help me

Best regards

Giovanni

[torsten_ziegler]

Dear Giovanni,

From the trace it looks like user "SAPTST" cannot execute the procedure SYSPROC.ENV_GET_REG_VARIABLES.

I suggest you run script db6_update_db from SAP Note 1365982. This should fix the problem.

Regards,

Torsten

From the trace:

4 ETW000 [ dev trc,00000] &+ DbSlConnectDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0551N "SAPTST" does not have the required au
4 ETW000 35 0.789408
4 ETW000 [ dev trc,00000] &+ thorization or privilege to perform operation "EXECUTE" on object "SYSPROC.ENV_GET_REG_VARIABLES". SQLSTATE=42501

[Frank-Martin]

Torsten is right ... Problem is described in SAP note

1977966 - DB6: SQL0551N on SYSPROC.ENV_GET_REG_VARIABLES

Regards Frank