Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2014
    Posts
    13

    Unanswered: Checkpoint in DB2

    how can configure checkpoint in DB2 and testing it to know if it work correctly or not??
    in Informix onmode -c command force checkpoint, Does FB2 have such command to force checkpoint?
    if checkpoint occure , where we can see logging of it? db2diag show this log or not?
    thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What do you expect this "checkpoint" to do, and why do you think you need to force it?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2014
    Posts
    13
    i want to configure checkpoint for recovery , i want to force it to test whether it lock database or not..
    thanks

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Can you please explain what you mean by "checkpoint for recovery"? I'm asking because in DB2 "checkpoint" may not mean what you think it means based on the experience with Informix.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2014
    Posts
    13
    why it dont mean in DB2? i want to set checkpoint to transfer log record to database when checkpoint occur. and when error occur db2 can recover database from checkpoint

  6. #6
    Join Date
    Jan 2014
    Posts
    13
    why checkpoint dont mean in DB2? how Db2 work when crash occur to commit transaction in log file????? i'm confused

  7. #7
    Join Date
    Jan 2014
    Posts
    13
    why checkpoint dont mean in db2?

  8. #8
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    If we are talking about LUW, you should read about proactive page cleaning.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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