1

Topic: Problem with a stop of basis for full

How such can be and what with it to do?
11/11/2017 1:00:01,96 - offline backup
quiesce instance db2 restricted access immediate force connections
DB20000I The QUIESCE INSTANCE command completed successfully.
DEACTIVATE DB nftg_db
DB20000I The DEACTIVATE DATABASE command completed successfully.
BACKUP DB xxx_db user xxx using xxx TO "H: \" WITH 4 BUFFERS COMPRESS WITHOUT PROMPTING
SQL1035N The operation failed because the specified database cannot be
connected to in the mode requested. SQLSTATE=57019
Here it from a gangway:
Failing instruction at 000007FEF7314154 offset: 00000000000008A4 in <__ intel_new_memset> <NotFound:-1>
I correctly understand, what it is necessary to increase database memory?

2

Re: Problem with a stop of basis for full

Toshkin;
Storage here, most likely, at anything.
It would be necessary all db2diag.log in this time - from the beginning  and before error obtaining.

3

Re: Problem with a stop of basis for full

Mark Barinstein;
Put a broad gull

4

Re: Problem with a stop of basis for full

Toshkin;
All from under DB2ADMIN...
At you after quiesce any application tried to activate basis, at the same time, when other agent wanted to fulfill backup.
If do not want, that so happened, do not start application from the user having SYSADM, SYSCTRL or SYSMAINT authorization in system.
[spoiler db2diag.log]

 2017-11-11-01.00.13.711000+180 E50124232F530 LEVEL: Warning
PID: 2944 TID: 6532 PROC: db2syscs.exe
INSTANCE: DB2 NODE: 000 DB:
APPHDL: 0-52814 APPID: *LOCAL.DB2.171110220003
AUTHID: DB2ADMIN HOSTNAME: Base-DB2
EDUID: 6532 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, base sys utilities, sqleInstanceQuiesce, probe:2
MESSAGE: ADM7501W Instance quiesce request has completed successfully.
...
2017-11-11-01.00.31.341000+180 E50175158F521 LEVEL: Event
PID: 2944 TID: 3800 PROC: db2syscs.exe
INSTANCE: DB2 NODE: 000 DB: NFTG_DB
APPHDL: 0-52807 [color=red] APPID: 192.168.1.201.63952.171110220009 [/color]
AUTHID: DB2ADMIN HOSTNAME: Base-DB2
EDUID: 3800 EDUNAME: db2agent (NFTG_DB) 0
FUNCTION: DB2 UDB, base sys utilities, [color=red] sqeLocalDatabase:: FirstConnect [/color], probe:1000
START: DATABASE: NFTG_DB: ACTIVATED: NO
...
2017-11-11-01.00.31.356000+180 I50175681F637 LEVEL: Error
PID: 2944 TID: 4848 PROC: db2syscs.exe
INSTANCE: DB2 NODE: 000 DB: NFTG_DB
APPHDL: 0-52815 APPID: *LOCAL.DB2.171110220026
AUTHID: DB2ADMIN HOSTNAME: Base-DB2
EDUID: 4848 EDUNAME: db2agent (NFTG_DB) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase:: SubsequentConnect, probe:11809
MESSAGE: ZRC=0xFFFFFBF5 =-1035
SQL1035N The operation failed because the specified database cannot
be connected to in the mode requested.

[/spoiler]

5

Re: Problem with a stop of basis for full

Mark Barinstein;
Thanks!
if it depended on me...