|
DB2 9.7.10 на WIndows Server 2012 Datacenter
|
|||
---|---|---|---|
#18+
Помогите с установкой. Сервер в домене но все работы с DB2 происходят под локальной учетной записью db2admin на начальном этапе входит в группу Администратор после установки DB2 db2admin добавлен в группу DB2ADMINS сразу после установки центр управления запустился а вот после перезагрузки всего сервера при запуске центра управления появляется ошибка Ошибка в файле db2nodes.cfg, строка номер "0". Код причины "3" . при этом файл db2nodes.cfg реально находится в каталоге C:\ProgramData\IBM\DB2\DB2COPY1\DB2\ он там есть и его можно редактировать содержимое файла 0 sw099000083184 SW099000083184 0 сам сервер при этом работает, БД с сервера TSM восстановил успешно. Подключение к БД проходит. ... |
|||
:
Нравится:
Не нравится:
|
|||
15.11.2019, 09:44 |
|
DB2 9.7.10 на WIndows Server 2012 Datacenter
|
|||
---|---|---|---|
#18+
Chumakov_JA, db2nodes.cfg если есть, то должен быть по следующему пути, если запускать из db2cwadmin: Код: plaintext
Скорее всего, это он и есть. Что выдает коменда ниже? Код: plaintext
... |
|||
:
Нравится:
Не нравится:
|
|||
15.11.2019, 14:21 |
|
DB2 9.7.10 на WIndows Server 2012 Datacenter
|
|||
---|---|---|---|
#18+
Mark Barinstein Chumakov_JA, Что выдает коменда ниже? Код: plaintext
SW099000083184 ... |
|||
:
Нравится:
Не нравится:
|
|||
15.11.2019, 15:36 |
|
DB2 9.7.10 на WIndows Server 2012 Datacenter
|
|||
---|---|---|---|
#18+
[quot Mark Barinstein#22017235]Chumakov_JA, Код: plaintext
результат D:\IBM\SQLLIB\BIN>FOR /F %i IN ('db2set DB2INSTPROF') DO echo %i\%DB2INSTANCE%\d b2nodes.cfg D:\IBM\SQLLIB\BIN>echo C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\db2nodes.cfg C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\db2nodes.cfg D:\IBM\SQLLIB\BIN> на сервере файл находится C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2nodes.cfg ... |
|||
:
Нравится:
Не нравится:
|
|||
15.11.2019, 15:41 |
|
DB2 9.7.10 на WIndows Server 2012 Datacenter
|
|||
---|---|---|---|
#18+
Chumakov_JA, Что выдает: Код: plaintext
... |
|||
:
Нравится:
Не нравится:
|
|||
15.11.2019, 19:43 |
|
DB2 9.7.10 на WIndows Server 2012 Datacenter
|
|||
---|---|---|---|
#18+
Mark Barinstein Chumakov_JA, Что выдает: Код: plaintext
D:\IBM\SQLLIB\BIN>db2set -all [e] DB2PATH=D:\IBM\SQLLIB [i] DB2INSTOWNER=SW099000083184 [i] DB2PORTRANGE=60000:60003 [i] DB2INSTPROF=C:\PROGRAMDATA\IBM\DB2\DB2COPY1 [i] DB2COMM=TCPIP [g] DB2_EXTSECURITY=YES [g] DB2_COMMON_APP_DATA_PATH=C:\ProgramData [g] DB2SYSTEM=SW099000083184 [g] DB2PATH=D:\IBM\SQLLIB [g] DB2INSTDEF=DB2 [g] DB2ADMINSERVER=DB2DAS00 D:\IBM\SQLLIB\BIN> ... |
|||
:
Нравится:
Не нравится:
|
|||
16.11.2019, 14:59 |
|
DB2 9.7.10 на WIndows Server 2012 Datacenter
|
|||
---|---|---|---|
#18+
кусок db2diag.log для облегчения понимания 2019-11-16-15.00.49.011000+180 I233549F411 LEVEL: Event PID : 1824 TID : 2908 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 2908 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104 DATA #1 : String, 26 bytes Force phase is in progress DATA #2 : Hexdump, 4 bytes 0x0000000014BBFEF0 : 0100 0000 .... 2019-11-16-15.00.49.011000+180 I233962F662 LEVEL: Event PID : 1824 TID : 1960 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1960 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1040 DATA #1 : String, 49 bytes [ForceSN]->Number of applications to be forced : DATA #2 : Hexdump, 4 bytes 0x000000000B14F5F4 : 0000 0000 .... DATA #3 : String, 43 bytes [ForceSN]->Number of system applications : DATA #4 : Hexdump, 4 bytes 0x000000000B14F5F0 : 0200 0000 .... 2019-11-16-15.00.49.011000+180 I234626F395 LEVEL: Event PID : 1824 TID : 1960 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1960 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1040 DATA #1 : String, 51 bytes [ForceSN]->Posting back to stop, no-appls to force. 2019-11-16-15.00.49.011000+180 I235023F334 LEVEL: Event PID : 1824 TID : 2908 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 2908 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108 DATA #1 : String, 47 bytes Force phase is completed and preparing to stop. 2019-11-16-15.00.49.011000+180 I235359F414 LEVEL: Event PID : 1824 TID : 2908 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 2908 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210 DATA #1 : String, 29 bytes Deactivate phase is bypassed. DATA #2 : Hexdump, 4 bytes 0x0000000014BBFEEC : 0100 0000 .... 2019-11-16-15.00.49.011000+180 I235775F434 LEVEL: Event PID : 1824 TID : 2908 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 2908 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230 DATA #1 : String, 49 bytes Deactivate phase is completed, preparing to stop. DATA #2 : Hexdump, 4 bytes 0x0000000014BBFEEC : 0100 0000 .... 2019-11-16-15.00.49.011000+180 I236211F313 LEVEL: Event PID : 1824 TID : 2908 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 2908 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240 DATA #1 : String, 26 bytes Stop phase is in progress. 2019-11-16-15.00.49.011000+180 I236526F328 LEVEL: Event PID : 1824 TID : 2908 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 2908 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250 DATA #1 : String, 41 bytes Requesting system controller termination. 2019-11-16-15.00.49.199000+180 I236856F464 LEVEL: Warning PID : 1824 TID : 1960 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1960 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5 MESSAGE : Bringing down all db2fmp processes as part of db2stop DATA #1 : Hexdump, 4 bytes 0x000000000B14F810 : 0000 0000 .... 2019-11-16-15.00.49.199000+180 E237322F404 LEVEL: Warning PID : 1824 TID : 1960 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1960 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6 DATA #1 : String, 36 bytes As part of db2stop terminating fmp: DATA #2 : Process ID, 4 bytes 1220 2019-11-16-15.00.49.199000+180 E237728F404 LEVEL: Warning PID : 1824 TID : 1960 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1960 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6 DATA #1 : String, 36 bytes As part of db2stop terminating fmp: DATA #2 : Process ID, 4 bytes 2008 2019-11-16-15.00.49.245000+180 I238134F330 LEVEL: Event PID : 1824 TID : 2908 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 2908 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260 DATA #1 : String, 43 bytes System controller termination is completed. 2019-11-16-15.00.49.245000+180 I238466F351 LEVEL: Event PID : 1824 TID : 2908 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 2908 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280 DATA #1 : String, 24 bytes There is no active EDUs. DATA #2 : unsigned integer, 4 bytes 0 2019-11-16-15.00.49.277000+180 E238819F327 LEVEL: Event PID : 1824 TID : 2908 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 2908 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911 MESSAGE : ADM7514W Database manager has stopped. STOP : DB2 DBM 2019-11-16-15.18.09.617000+180 E239148F888 LEVEL: Warning PID : 1748 TID : 1840 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1840 FUNCTION: DB2 UDB, license manager, sqllcRequestAccess, probe:1 MESSAGE : ADM12007E There are "86" day(s) left in the evaluation period for the product "DB2 Enterprise Server Edition". For evaluation license terms and conditions, refer to the IBM License Acceptance and License Information document located in the license directory in the installation path of this product. If you have licensed this product, ensure the license key is properly registered. You can register the license via the License Center or db2licm command line utility. The license file can be obtained from your licensed product CD. 2019-11-16-15.18.09.664000+180 I240038F393 LEVEL: Warning PID : 1748 TID : 1840 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1840 FUNCTION: DB2 UDB, license manager, sqllcRequestAccess, probe:1 MESSAGE : SQL8007W There are "86" days left in the evaluation period for the product "DB2 Enterprise Server Edition". 2019-11-16-15.18.13.688000+180 I240433F544 LEVEL: Event PID : 1748 TID : 1892 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1892 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10 START : Starting FCM Buffer Manager 1 resource group(s). 128 buffers allocated. Maximum number of buffers supported is 8192. Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 925712 bytes. 2019-11-16-15.18.13.720000+180 I240979F551 LEVEL: Event PID : 1748 TID : 1892 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1892 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10 START : Starting FCM Channel Manager 1 resource group(s). 128 channels allocated. Maximum number of channels supported is 8192. Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 507928 bytes. 2019-11-16-15.18.13.720000+180 I241532F550 LEVEL: Event PID : 1748 TID : 1892 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1892 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10 START : Starting FCM Session Manager 1 resource group(s). 128 sessions allocated. Maximum number of sessions supported is 64000. Total session manager memory required for 1 logical and 0 fail-over partitions is 1683456 bytes. 2019-11-16-15.18.13.735000+180 I242084F428 LEVEL: Event PID : 1748 TID : 1892 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1892 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500 START : FCM infrastructure started FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IPv4 2019-11-16-15.18.15.483000+180 E242514F874 LEVEL: Event PID : 1748 TID : 1840 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 EDUID : 1840 FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911 MESSAGE : ADM7513W Database manager has started. START : DB2 DBM DATA #1 : Build Level, 152 bytes Instance "DB2" uses "64" bits and DB2 code release "SQL0907B" with level identifier "080C0107". Informational tokens are "DB2 v9.7.1100.352", "s150922", "IP23939", Fix Pack "11". DATA #2 : System Info, 1568 bytes System: WIN32_NT SW099000083184 6.2 AMD64 Family 6, model 47, stepping 2 CPU: total:12 online:12 Cores per socket:16 Threading degree per core:1 Physical Memory(MB): total:66560 free:63298 available:63298 Virtual Memory(MB): total:67360 free:64098 Swap Memory(MB): total:800 free:800 2019-11-16-15.22.07.223000+180 I243390F741 LEVEL: Severe PID : 892 TID : 1216 PROC : db2systray.exe INSTANCE: DB2 NODE : 000 EDUID : 1216 FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32 MESSAGE : ZRC=0xFFFFE871=-6031 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -6031 sqlerrml: 3 sqlerrmc: 0 3 sqlerrp : SQLFRCFG 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: лицнзия есть, просто пока разбираюсь не стал этого делать. ... |
|||
:
Нравится:
Не нравится:
|
|||
16.11.2019, 15:12 |
|
|
start [/forum/topic.php?fid=43&msg=39889379&tid=1600219]: |
0ms |
get settings: |
11ms |
get forum list: |
15ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
64ms |
get topic data: |
11ms |
get forum data: |
3ms |
get page messages: |
48ms |
get tp. blocked users: |
1ms |
others: | 322ms |
total: | 483ms |
0 / 0 |