Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2011
    Posts
    21

    Unanswered: SQL2563W when restore a db, ADM10500E appears in log

    Hi,

    I got a lot of error message in db2diag.log listed as bellow. The error was reported to almost every databases in my db2 instance.


    What should I do to make my db functioning?

    Thanks,
    Dixie

    2011-10-27-08.43.32.313000+660 E896188F636 LEVEL: Error
    PID : 6024 TID : 3724 PROC : db2fmp64.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 3724
    FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
    MESSAGE : ADM10500E Health indicator "Log Filesystem Utilization"
    ("db.log_fs_util") breached the "upper" alarm threshold of "85 %"
    with value "94 %" on "database" "DB2.QM ". Calculation:
    "((os.fs_used/os.fs_total)*100);" = "((59224264704 / 62807601152) *
    100)" = "94 %". History (Timestamp, Value, Formula): "()"
    Last edited by dixiefu; 10-26-11 at 19:38.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by dixiefu View Post
    SQL2563W when restore a db
    SQL2563W The restore process has completed successfully, but one or
    more table spaces from the backup were not restored.


    Check your restore - it looks like some tablespace(s) were not restored.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    the adm message is just the health monitor checking the usage of the filesystem where the logs are located
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •