Updated docker today and I have noticed that the IBMdb2 image stopped working it seems like.
When I execute a query from intellij I get the following reply:
[2020-05-12 09:37:36] [58005][-902] java.sql.SQLException.I looked at the logs and I can see the following. I have attempted to highlight the things I find standout:
---
2020-05-12-07.39.02.501732+000 I303090E331 LEVEL: Event
PID : 16255 TID : 139808343435136 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
HOSTNAME: 1e5865fdf66f
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
(*) Restoring global registry file ...
(*) Preparing the environment before updating the instance ...
(*) Fixing /etc/services file for DB2 ...
(*) Creating instance ...
DBI1446I The db2icrt command is running.
DB2 installation is being initialized.
Total number of tasks to be performed: 4
Total estimated time for all tasks to be performed: 309 second(s)
Task #1 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #1 end
Task #2 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #2 end
Task #3 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #3 end
Task #4 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #4 end
The execution completed successfully.
For more information see the DB2 installation log at "/tmp/db2icrt.log.56".
DBI1070I Program db2icrt completed successfully.
chown: cannot access '/database/config/db2inst1/sqllib/adm/fencedid': No such file or directory
05/12/2020 07:39:38 0 0 SQL1032N No start database manager command was issued.
SQL1032N No start database manager command was issued. SQLSTATE=57019
(*) Cataloging existing databases
(*) Cataloging database DB2LOCAL on /database/data ...
SQL1005N The database alias "DB2LOCAL" already exists in either the local
database directory or system database directory.
(*) Importing existing license configurations ...
(*) Updating DBM CFG parameters ...
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
No Cgroup memory limit detected, instance memory will follow automatic tuning
(*) Remounting /database with suid...
(*) Cannot retrieve db2 database configuration parameters. Calling an upgrade.
(*) Upgrading database db2local ...
05/12/2020 07:39:52 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
SQL1005N The database alias "db2local" already exists in either the local
database directory or system database directory.
SQL0902C A system error occurred. Subsequent SQL statements cannot beprocessed. IBM software support reason code: "". SQLSTATE=58005_________________________________________________________________________
_____ DB2 Service Tools _____
I B M
db2updv115
This tool is a service utility designed to update a DB2 Version 11.5
database to the current fix pack level.
_________________________________________________________________________
DB2 Universal Database Version 11.5, 5622-044 (c) Copyright IBM Corp. 2017
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool
MESSAGE: Connect to database 'db2local' failed with sqlcode = -902.db2updv115 processing failed for database 'db2local'.DB2 State : Available
DB2 has been started
mkdir: cannot create directory '/var/log/supervisor': File exists
Unlinking stale socket /var/run/supervisor.sock
(*) All databases are now active.
(*) Setup has completed.
FUNCTION: DB2 UDB, Common Trace API, sqlrl_db2updv, probe:1671
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1024 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLIMPCN
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 08003
2020-05-12-07.39.59.923810+000 I382675E475 LEVEL: Warning
PID : 14099 TID : 140107157993344 PROC : db2cfexp
INSTANCE: db2inst1 NODE : 000
HOSTNAME: 1e5865fdf66f
FUNCTION: DB2 UDB, Client Config, cfgExportProfileItems, probe:1
MESSAGE : Header:
DATA #1 : Hexdump, 32 bytes
0x00007FFE5F1C4200 : 2A2A 2A2A 2045 5850 4F52 5420 2A2A 2A2A **** EXPORT ****
0x00007FFE5F1C4210 : 2A20 2020 2020 5354 4152 5420 2020 202A * START *
2020-05-12-07.39.59.923983+000 I383151E370 LEVEL: Warning
PID : 14099 TID : 140107157993344 PROC : db2cfexp
INSTANCE: db2inst1 NODE : 000
HOSTNAME: 1e5865fdf66f
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging function), probe:30
MESSAGE : ProfileName
DATA #1 : String, 25 bytes
/database/config/dbdbmcfg
2020-05-12-07.39.59.933070+000 I383522E477 LEVEL: Warning
PID : 14099 TID : 140107157993344 PROC : db2cfexp
INSTANCE: db2inst1 NODE : 000
HOSTNAME: 1e5865fdf66f
FUNCTION: DB2 UDB, Client Config, cfgExportProfileItems, probe:253
MESSAGE : Header:
DATA #1 : Hexdump, 32 bytes
0x00007FFE5F1C4200 : 2A20 2020 2020 454E 4420 2020 2020 202A * END *
0x00007FFE5F1C4210 : 2A2A 2A2A 2045 5850 4F52 5420 2A2A 2A2A **** EXPORT ****
When I fire a query toward the database I get:2020-05-12-07.42.02.239254+000 I384000E475 LEVEL: Warning
PID : 14527 TID : 140221912594304 PROC : db2cfexp
INSTANCE: db2inst1 NODE : 000
HOSTNAME: 1e5865fdf66f
FUNCTION: DB2 UDB, Client Config, cfgExportProfileItems, probe:1
MESSAGE : Header:
DATA #1 : Hexdump, 32 bytes
0x00007FFC40942500 : 2A2A 2A2A 2045 5850 4F52 5420 2A2A 2A2A **** EXPORT ****
0x00007FFC40942510 : 2A20 2020 2020 5354 4152 5420 2020 202A * START *
2020-05-12-07.42.02.239411+000 I384476E370 LEVEL: Warning
PID : 14527 TID : 140221912594304 PROC : db2cfexp
INSTANCE: db2inst1 NODE : 000
HOSTNAME: 1e5865fdf66f
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging function), probe:30
MESSAGE : ProfileName
DATA #1 : String, 25 bytes
/database/config/dbdbmcfg
2020-05-12-07.42.02.246865+000 I384847E477 LEVEL: Warning
PID : 14527 TID : 140221912594304 PROC : db2cfexp
INSTANCE: db2inst1 NODE : 000
HOSTNAME: 1e5865fdf66f
FUNCTION: DB2 UDB, Client Config, cfgExportProfileItems, probe:253
MESSAGE : Header:
DATA #1 : Hexdump, 32 bytes
0x00007FFC40942500 : 2A20 2020 2020 454E 4420 2020 2020 202A * END *
0x00007FFC40942510 : 2A2A 2A2A 2045 5850 4F52 5420 2A2A 2A2A **** EXPORT ****
2020-05-12-07.42.46.085161+000 I385325E725 LEVEL: Event
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 Common, Cryptography, cryptContextRealInit, probe:1774
DATA #1 : String, 37 bytes
CPU flags(string): 0xfeda32035f8bfbff
DATA #2 : String, 37 bytes
CPU flags(Uint64): 0xFEDA32035F8BFBFF
DATA #3 : String, 56 bytes
Encryption hardware acceleration detected - Intel AES-NI
DATA #4 : String, 56 bytes
Encryption hardware acceleration detected - Intel RDrand
2020-05-12-07.42.46.122216+000 I386051E681 LEVEL: Event
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, base sys utilities, sqleCalculateDbHeaps, probe:70
MESSAGE : RLMS - DB Memory Set for Resident Member
DATA #1 : String, 10 bytes
totalBytes
DATA #2 : unsigned integer, 8 bytes
632815616
DATA #3 : String, 11 bytes
dbHeapBytes
DATA #4 : unsigned integer, 8 bytes
214499328
2020-05-12-07.42.46.224700+000 E386733E618 LEVEL: Warning
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:1770
DATA #1 : <preformatted>
Readlog buffer sizes
sizeXLogReadBufLarge: 8
numXLogReadBufLarge: 15
numXLogReadBufSmall: 39
numXLogReadBuf: 54
numPagesForReadLog: 160
2020-05-12-07.42.46.226131+000 I387352E517 LEVEL: Info
PID : 13651 TID : 140341395056384 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: 1e5865fdf66f
EDUID : 42 EDUNAME: db2logts (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, SQLP_LOGTS_LOG_FILES_INFO::increaseInfoForLogTableSize, probe:564
MESSAGE : Increasing size of log skipping info for log table. New maximum
number of entries:
DATA #1 : unsigned integer, 8 bytes
256
2020-05-12-07.42.46.230161+000 I387870E578 LEVEL: Info
PID : 13651 TID : 140341411833600 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
HOSTNAME: 1e5865fdf66f
EDUID : 44 EDUNAME: db2loggr (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, sqlpgLogFileTable::addElement, probe:188
MESSAGE : Increasing size of log file (read) table. New maximum number of
elements:
DATA #1 : unsigned integer, 8 bytes
256
DATA #2 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
0
2020-05-12-07.42.46.253154+000 I388449E723 LEVEL: Info
PID : 13651 TID : 140341403444992 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
HOSTNAME: 1e5865fdf66f
EDUID : 43 EDUNAME: db2logmgr (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, sqpLogMgrEdu::sqlpgHandleLogMgrPost, probe:7015
DATA #1 : <preformatted>
Log Manager started for log stream 0.
Log Archive Method 1: DISK
First Extent to be Archived: 1315
Next Extent to Archive: 1315
First Failed Archive: 1315
Log Archive Method 2: OFF
First Extent to be Archived: 4294967295
Next Extent to Archive: 4294967295
First Failed Archive: 4294967295
2020-05-12-07.42.46.286461+000 I389173E440 LEVEL: Info
PID : 13651 TID : 140341411833600 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
HOSTNAME: 1e5865fdf66f
EDUID : 44 EDUNAME: db2loggr (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog, probe:1440
DATA #1 : <preformatted>
Cleaning up old log files from 1314 to 1315.
2020-05-12-07.42.46.287353+000 E389614E1597 LEVEL: Info
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, sqlpMasterDbcb::displayDatabaseStartupMessage, probe:1500
DATA #1 : <preformatted>
Database is starting up with the following values:
Primary active log path: /database/data/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/
Mirror active log path: not defined
Log Chain ID: 0
File Count: 16
Head Extent ID: 1315
Group Head Extent ID: 1315
Rename Arch Num: 1314
Log Primary: 16
Log Second: 22
Log File Size: 1024
Total Log Space: 66777108
Startup LSO: 0
Base LSO: 5533414561
Last Log Record LSO: 5529391621
Last Log Record LFS: 1269478
Last Log Record LSN: 0000000002AA5A84
Next LSN: 0000000002AA5A85
Lowtran LSN: 0000000002AA5A85
Minbuff LSN: 0000000002AA5A85
Head LSN: 0000000002AA5A85
Group Head LSN: 0000000002AA5A85
Group Minbuff LSN: 0000000002AA5A85
Current Write Log Extent Limit: 5537588385
2020-05-12-07.42.46.287652+000 I391212E667 LEVEL: Info
PID : 13651 TID : 140341411833600 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
HOSTNAME: 1e5865fdf66f
EDUID : 44 EDUNAME: db2loggr (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, sqlpgReadLogExtentXhdr, probe:4275
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
0
DATA #2 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
1314
DATA #3 : Hex integer, 8 bytes
0x0000000000000003
2020-05-12-07.42.46.299894+000 E391880E836 LEVEL: Warning
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:20
DATA #1 : <preformatted>
Reserved heap size exceeded for Kernel(BSU) Heap on node 0,
allocating additional unreserved memory.
Requested block size : 8521344 bytes.
Physical heap size : 41484288 bytes.
Configured heap size : 35061760 bytes.
Unreserved memory used by heap : 6422528 bytes.
Unreserved memory left in set : 7012352 bytes.
2020-05-12-07.42.46.630059+000 I392717E3053 LEVEL: Error (OS)PID : 13651 TID : 140341428610816 PROC : db2sysc 0INSTANCE: db2inst1 NODE : 000 DB : DB2LOCALAPPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66fEDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:140MESSAGE : ECF=0x90000005=-1879048187=ECF_NOT_SUPPORTED Functionality not supportedCALLED : OS, -, statfs OSERR: ENOSYS (38)DATA #1 : String, 63 bytes/database/data/db2inst1/NODE0000/DB2LOCAL/T0000000/C0000000.CATDATA #2 : unsigned integer, 8 bytes2050CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007FA3D84D454B /home/db2inst1/sqllib/lib64/libdb2osse.so.1 + 0x24754B [1] 0x00007FA3D84D5A51 ossLogSysRC + 0x101 [2] 0x00007FA3D84F0398 ossGetDiskInfo + 0x1088 [3] 0x00007FA3E1ED486E sqloFetchAndStoreFSInfoInFileHandle + 0x29E [4] 0x00007FA3DB371C24 _Z32sqlbFetchAndStoreContainerFSInfoP16SQLB_POOLCONT_CBb + 0x54 [5] 0x00007FA3DB328A4D _Z16sqlbDMSStartPoolP12SQLB_GLOBALSP12SQLB_POOL_CBb + 0x70D [6] 0x00007FA3DB0810C3 _Z14sqlbStartPoolsP12SQLB_GLOBALS + 0x813 [7] 0x00007FA3DB1D3056 sqlbinit + 0x53E7 [8] 0x00007FA3E00ECD77 _Z8sqledintP8sqeAgentP16sqeLocalDatabaseP5sqlcacPciPbm + 0x12E7 [9] 0x00007FA3E00E33AD _ZN16sqeLocalDatabase12FirstConnectEP8SQLE_BWARcP8sqeAgentP8sqlo_gmtiiPb + 0x50FD [10] 0x00007FA3E00C4A0D _ZN8sqeDBMgr23StartUsingLocalDatabaseEP8SQLE_BWAP8sqeAgentRccP8sqlo_gmtPb + 0xF5D [11] 0x00007FA3DFFCD8F2 _ZN14sqeApplication13AppStartUsingEP8SQLE_BWAP8sqeAgentccP5sqlcaPc + 0x402 [12] 0x00007FA3DFFE193C _Z22sqleProcessConnectTypeP14db2UCinterfaceP8SQLE_BWAP8sqeAgentP5sqlcaP22SQLELOST_STATUS_VECTOR + 0xAC [13] 0x00007FA3DFFCBFE0 _ZN14sqeApplication13AppLocalStartEP14db2UCinterface + 0x7B0 [14] 0x00007FA3E0394BDF _Z11sqlelostWrpP14db2UCinterface + 0x4F [15] 0x00007FA3E039AA91 _Z14sqleUCengnInitP14db2UCinterfacet + 0x891 [16] 0x00007FA3E03910EC sqleUCagentConnect + 0x89C [17] 0x00007FA3E063BDAD _Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface + 0x2ED [18] 0x00007FA3E05CA42B _Z16sqljs_ddm_accsecP14db2UCinterfaceP13sqljDDMObject + 0x8B [19] 0x00007FA3E05BE35D _Z17sqljsParseConnectP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x1ED [20] 0x00007FA3E05BF57E _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x54E [21] 0x00007FA3E05B24E6 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x7B424E6 [22] 0x00007FA3E05B8B33 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x7B48B33 [23] 0x00007FA3E05B97EF _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x11F [24] 0x00007FA3DFFB33A3 _ZN8sqeAgent6RunEDUEv + 0xDE3 [25] 0x00007FA3E3A8345E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE [26] 0x00007FA3E1EEC08A sqloEDUEntry + 0x57A [27] 0x00007FA3EA940DD5 /lib64/libpthread.so.0 + 0x7DD5 [28] 0x00007FA3D7505EAD clone + 0x6D2020-05-12-07.42.46.649685+000 I395771E661 LEVEL: Severe
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbFetchAndStoreContainerFSInfo, probe:10
MESSAGE : ECF=0x90000005=-1879048187=ECF_NOT_SUPPORTED
Functionality not supported
DATA #1 : File name, 63 bytes
/database/data/db2inst1/NODE0000/DB2LOCAL/T0000000/C0000000.CAT
2020-05-12-07.42.46.649898+000 I396433E603 LEVEL: Error
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSStartPool, probe:804
MESSAGE : ECF=0x90000005=-1879048187=ECF_NOT_SUPPORTED
Functionality not supported
DATA #1 : <preformatted>
Tablespace 0 (SYSCATSPACE)
2020-05-12-07.42.46.650110+000 E397037E647 LEVEL: Error
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2542
MESSAGE : ADM6023I The table space "SYSCATSPACE" (ID "0") is in state
"0x00000000". The table space cannot be accessed. Refer to the
documentation for SQLCODE -290.
2020-05-12-07.42.46.650457+000 I397685E550 LEVEL: Error
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2542
MESSAGE : ECF=0x90000005=-1879048187=ECF_NOT_SUPPORTED
Functionality not supported
2020-05-12-07.42.46.650614+000 I398236E543 LEVEL: Error
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:590
MESSAGE : ECF=0x90000005=-1879048187=ECF_NOT_SUPPORTED
Functionality not supported
2020-05-12-07.42.46.666415+000 I398780E543 LEVEL: Severe
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:6282
MESSAGE : ECF=0x90000005=-1879048187=ECF_NOT_SUPPORTED
Functionality not supported
2020-05-12-07.42.46.666635+000 I399324E924 LEVEL: SeverePID : 13651 TID : 140341428610816 PROC : db2sysc 0INSTANCE: db2inst1 NODE : 000 DB : DB2LOCALAPPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66fEDUID : 22 EDUNAME: db2agent (DB2LOCAL) 0FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10872DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 0 sqlerrmc: sqlerrp : SQL11050 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate:DATA #2 : Boolean, 1 bytesfalse2020-05-12-07.42.46.668082+000 E400249E1044 LEVEL: Info
PID : 13651 TID : 140341411833600 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
HOSTNAME: 1e5865fdf66f
EDUID : 44 EDUNAME: db2loggr (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:2820
DATA #1 : <preformatted>
Log stream 0 has been marked consistent.
File Count: 16
Head Extent ID: 1315
Group Head Extent ID: 1315
Rename Arch Num: 1314
Startup LSO: 0
Base LSO: 5533414561
Last Log Record LSO: 5529391621
Last Log Record LSN: 0000000002AA5A84
Next LSN: 0000000002AA5A85
Lowtran LSN: 0000000002AA5A85
Minbuff LSN: 0000000002AA5A85
Head LSN: 0000000002AA5A85
Group Head LSN: 0000000002AA5A85
Group Minbuff LSN: 0000000002AA5A85
2020-05-12-07.42.46.668283+000 E401294E562 LEVEL: Info
PID : 13651 TID : 140341411833600 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
HOSTNAME: 1e5865fdf66f
EDUID : 44 EDUNAME: db2loggr (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:2889
DATA #1 : <preformatted>
Database has been marked consistent.
Log Chain ID: 0
Log Primary: 16
Log Second: 22
Log File Size: 1024
2020-05-12-07.42.46.668559+000 I401857E486 LEVEL: Info
PID : 13651 TID : 140341403444992 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
HOSTNAME: 1e5865fdf66f
EDUID : 43 EDUNAME: db2logmgr (DB2LOCAL) 0
FUNCTION: DB2 UDB, data protection services, sqpLogMgrEdu::sqlpgHandleLogMgrPost, probe:9000
DATA #1 : <preformatted>
Log Manager has been requested by database shutdown to stop for log stream 0.
2020-05-12-07.42.47.398815+000 E402344E528 LEVEL: Event
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (idle) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FreeResourcesOnDBShutdown, probe:16479
STOP : DATABASE: DB2LOCAL : DEACTIVATED: NO
2020-05-12-07.42.47.399460+000 I402873E554 LEVEL: Warning
PID : 13651 TID : 140341428610816 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DB2LOCAL
APPHDL : 0-9 APPID: 172.17.0.1.37942.200512074246
AUTHID : DB2INST1 HOSTNAME: 1e5865fdf66f
EDUID : 22 EDUNAME: db2agent (idle) 0
FUNCTION: DB2 UDB, common communication, sqlcctcplogIPAddress, probe:50
MESSAGE : DIA3220W Client sent data from IP address = "172.17.0.1", port =
"13972".
------------------------------
Anders Vinther
------------------------------
#Db2