DB2 Backup strange Problem

vdileep

Hi,

I have 3 systems with db2 running on AIX. We take online backup on
weekdays and offline on saturday. For the past two weeks the offline
backup is getting terminated after exactly 2 hours 13 minutes on two
systems. I am getting a timestamp in the backup history file. The third
system takes only 30 minutes to backup. The db2diag.log file is attached
below. I increased the UTIL_HEAP_SZ parameter. Still no use. Can
somebody please tell me why this is happening.

Also for the past 1 month I am not able to stop db2 using db2stop. I
always have to use db2_kill.

2006-05-07-00.49.36.300161+330 I38570A378 LEVEL: Warning
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl,
probe:2025
MESSAGE : Starting an offline db backup.

2006-05-07-00.49.36.434173+330 E38949A509 LEVEL: Warning
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions,
probe:20
DATA #1 : <preformatted>
Configured heap limit exceeded for Backup/Restore/Util Heap
(UTIL_HEAP_SZ) on node 0. Allocating additional memory from the
overflow buffer.

2006-05-07-00.53.45.252407+330 I39459A411 LEVEL: Severe
PID : 70286 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-13 APPID: AC100897.KB0E.00E7C6191937
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-01.19.30.817373+330 I41519A411 LEVEL: Severe
PID : 13730 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-18 APPID: AC100897.LA0E.00E7C6194523
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-01.34.58.155469+330 I42755A411 LEVEL: Severe
PID : 52624 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-21 APPID: AC100897.M30E.00E7C6200050
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"
2006-05-07-01.50.25.585710+330 I43991A411 LEVEL: Severe
PID : 55204 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-24 APPID: AC100897.MB0E.00E7C6201618
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-01.55.34.694613+330 I44403A411 LEVEL: Severe
PID : 70190 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-25 APPID: AC100897.MF0E.00E7C6202127
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.00.43.814687+330 I44815A411 LEVEL: Severe
PID : 52574 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-26 APPID: AC100897.N10E.00E7C6202636
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.05.52.935864+330 I45227A411 LEVEL: Severe
PID : 52704 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-27 APPID: AC100897.N60E.00E7C6203145
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.11.02.042180+330 I45639A411 LEVEL: Severe
PID : 70754 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-28 APPID: AC100897.N80E.00E7C6203654
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.16.11.150675+330 I46051A411 LEVEL: Severe
PID : 52682 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-29 APPID: AC100897.NC0E.00E7C6204203
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.21.20.261072+330 I46463A411 LEVEL: Severe
PID : 54902 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-30 APPID: AC100897.NE0E.00E7C6204712
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.26.29.367765+330 I46875A411 LEVEL: Severe
PID : 70852 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-31 APPID: AC100897.O00E.00E7C6205221
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.31.38.473976+330 I47287A411 LEVEL: Severe
PID : 55056 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-32 APPID: AC100897.O40E.00E7C6205730
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.36.47.583247+330 I47699A411 LEVEL: Severe
PID : 13748 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-33 APPID: AC100897.O60E.00E7C6210240
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.41.56.705347+330 I48111A411 LEVEL: Severe
PID : 54912 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-34 APPID: AC100897.OB0E.00E7C6210749
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.47.05.812230+330 I48523A411 LEVEL: Severe
PID : 55140 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-35 APPID: AC100897.OD0E.00E7C6211258
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.52.14.920730+330 I48935A411 LEVEL: Severe
PID : 13584 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-39 APPID: AC100897.P10E.00E7C6211807
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.57.24.033026+330 I49347A411 LEVEL: Severe
PID : 13712 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-42 APPID: AC100897.P30E.00E7C6212316
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-03.00.40.934176+330 I49759A440 LEVEL: Severe
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, database utilities, sqlubPollMsg, probe:1
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0780000275180890 : FFFF F82F .../

2006-05-07-03.00.40.945802+330 I50200A420 LEVEL: Error
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, database utilities, sqlubPollMsg, probe:1
DATA #1 : Hexdump, 4 bytes
0x0780000275180890 : FFFF F82F .../

2006-05-07-03.00.52.375892+330 I50621A352 LEVEL: Severe
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:140
MESSAGE : Backup Terminated.

Dileep
--
vdileep
------------------------------------------------------------------------
vdileep's Profile: http://www.dbtalk.net/m311
View this thread: http://www.dbtalk.net/t304978

May 8 '06 #1

Subscribe Post Reply

5554

Bob [IBM]

vdileep wrote:

Hi,

I have 3 systems with db2 running on AIX. We take online backup on
weekdays and offline on saturday. For the past two weeks the offline
backup is getting terminated after exactly 2 hours 13 minutes on two
systems. I am getting a timestamp in the backup history file. The third
system takes only 30 minutes to backup. The db2diag.log file is attached
below. I increased the UTIL_HEAP_SZ parameter. Still no use. Can
somebody please tell me why this is happening.

Also for the past 1 month I am not able to stop db2 using db2stop. I
always have to use db2_kill.

2006-05-07-00.49.36.300161+330 I38570A378 LEVEL: Warning
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl,
probe:2025
MESSAGE : Starting an offline db backup.

2006-05-07-00.49.36.434173+330 E38949A509 LEVEL: Warning
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions,
probe:20
DATA #1 : <preformatted>
Configured heap limit exceeded for Backup/Restore/Util Heap
(UTIL_HEAP_SZ) on node 0. Allocating additional memory from the
overflow buffer.

2006-05-07-00.53.45.252407+330 I39459A411 LEVEL: Severe
PID : 70286 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-13 APPID: AC100897.KB0E.00E7C6191937
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-01.19.30.817373+330 I41519A411 LEVEL: Severe
PID : 13730 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-18 APPID: AC100897.LA0E.00E7C6194523
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-01.34.58.155469+330 I42755A411 LEVEL: Severe
PID : 52624 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-21 APPID: AC100897.M30E.00E7C6200050
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"
2006-05-07-01.50.25.585710+330 I43991A411 LEVEL: Severe
PID : 55204 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-24 APPID: AC100897.MB0E.00E7C6201618
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-01.55.34.694613+330 I44403A411 LEVEL: Severe
PID : 70190 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-25 APPID: AC100897.MF0E.00E7C6202127
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.00.43.814687+330 I44815A411 LEVEL: Severe
PID : 52574 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-26 APPID: AC100897.N10E.00E7C6202636
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.05.52.935864+330 I45227A411 LEVEL: Severe
PID : 52704 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-27 APPID: AC100897.N60E.00E7C6203145
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.11.02.042180+330 I45639A411 LEVEL: Severe
PID : 70754 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-28 APPID: AC100897.N80E.00E7C6203654
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.16.11.150675+330 I46051A411 LEVEL: Severe
PID : 52682 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-29 APPID: AC100897.NC0E.00E7C6204203
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.21.20.261072+330 I46463A411 LEVEL: Severe
PID : 54902 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-30 APPID: AC100897.NE0E.00E7C6204712
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.26.29.367765+330 I46875A411 LEVEL: Severe
PID : 70852 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-31 APPID: AC100897.O00E.00E7C6205221
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.31.38.473976+330 I47287A411 LEVEL: Severe
PID : 55056 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-32 APPID: AC100897.O40E.00E7C6205730
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.36.47.583247+330 I47699A411 LEVEL: Severe
PID : 13748 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-33 APPID: AC100897.O60E.00E7C6210240
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.41.56.705347+330 I48111A411 LEVEL: Severe
PID : 54912 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-34 APPID: AC100897.OB0E.00E7C6210749
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.47.05.812230+330 I48523A411 LEVEL: Severe
PID : 55140 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-35 APPID: AC100897.OD0E.00E7C6211258
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.52.14.920730+330 I48935A411 LEVEL: Severe
PID : 13584 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-39 APPID: AC100897.P10E.00E7C6211807
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-02.57.24.033026+330 I49347A411 LEVEL: Severe
PID : 13712 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2prd NODE : 000
APPHDL : 0-42 APPID: AC100897.P30E.00E7C6212316
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2006-05-07-03.00.40.934176+330 I49759A440 LEVEL: Severe
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, database utilities, sqlubPollMsg, probe:1
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0780000275180890 : FFFF F82F .../

2006-05-07-03.00.40.945802+330 I50200A420 LEVEL: Error
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, database utilities, sqlubPollMsg, probe:1
DATA #1 : Hexdump, 4 bytes
0x0780000275180890 : FFFF F82F .../

2006-05-07-03.00.52.375892+330 I50621A352 LEVEL: Severe
PID : 33470 TID : 1 PROC : db2agent (PRD)
0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-12 APPID: *LOCAL.db2prd.060506191919
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:140
MESSAGE : Backup Terminated.

Dileep

How large is the backup image just before it terminates? I suspect you
are hitting the file size limit? Is the file system where you are
placing the backup images large file enabled? If not then you may be
hitting the 2GB default file size limit.

Bob

May 8 '06 #2

vdileep

Hi

I am backing up on Tape. My DB size is more than 600 GB and I am
backing up on a 200/400 GB Tape. I am basically an AIX admin but I am
being asked to take care of db2 also now.
One more thing I forgot to tell you. We had installed Tivoli TSM on the
machines but it was not a success. So we are not using it. I wonder
whether any configuration was changed by TSM.
Also my online backup on the same database with same tape succeeds.

Thanks in advance

With Regards

Dileep
--
vdileep
------------------------------------------------------------------------
vdileep's Profile: http://www.dbtalk.net/m311
View this thread: http://www.dbtalk.net/t304978

May 10 '06 #3

vdileep

Hi,

The problem has been resolved. There was some monitoring tool which was
being run by the customer.

Thanks for all the help

Dileep
--
vdileep
------------------------------------------------------------------------
vdileep's Profile: http://www.dbtalk.net/m311
View this thread: http://www.dbtalk.net/t304978

May 15 '06 #4

Similar topics

CHANGED backup time, but still occuring

by: Doug | last post by:

Hello. Have a strange one here. I'm backing up databases locally to a drive on the server daily. I needed to change the time of the backup, and did that, but it's still occuring at the old time. ...

Microsoft SQL Server

Weird Backup DB Problems in SQL Server 7

by: jwbeaty | last post by:

Here's a weird one. I'm running SQL Server 7 and when I run a backup something weird happens. When I perform the backup via Enterprise Manager by right clicking on the database I want to...

Microsoft SQL Server

Changes since last backup?

by: bobdirls | last post by:

Hi, Is there any way of telling if a database or table has been updated, altered or deleted from since the last backup was made in SQL server. Windows does not correctly report .mdf file size...

Microsoft SQL Server

[?]Restore and Backup problem

by: Spieg | last post by:

I've a program with VB6 working with SQLServer 2000. I have a Central Station with the program runnin with full prvileges and that can perform all the actions on the DB. There are also some...

Microsoft SQL Server

EMC's Time Finder for DB backup

by: Wanhua Yi | last post by:

Hi all, anybody out there with experience in using EMC's Time Finder Software and DB2 UDB EEE on AIX ? Especially in using BCV for Backup ? Any white papers ?

DB2 Database

Backup of DB2 on Windows 2003 using open file option

by: Charles Morrall | last post by:

I have no experience with DB2 as such, but I've been tasked with configuring backup of a server running DB2 v8 on Windows Server 2003. I do have some experience with backups in general though. The...

DB2 Database

backup job hang

by: wyys.cn | last post by:

hi,everyone! I meet strange thing when I create a maintance job for backup all database. and this backup job just stands "Executing job step '(step 1)'" for a very long time . SQL server...

Microsoft SQL Server

SQL Server 2000 Transaction Log Backup Question

by: flobroed | last post by:

Hi, I've a question regarding the transaction-log backup on SQL-Server 2000. We have implemented a low cost replication. Every evening we make a full backup and beginning at 7 to 18 we make...

Microsoft SQL Server

db2 backup image file is having strange changes of sizes

by: yellr | last post by:

Hi guys, im facing a strange problem with the db2 backup size, our last backups have had the following sizes: 18G 24G 26G 20G

DB2 Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++