User Profile

Collapse

Profile Sidebar

Collapse
alex250374
alex250374
Last Activity: Oct 30 '09, 02:55 PM
Joined: Apr 4 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • alex250374
    started a topic BAckup online with include logs fails !!!
    in DB2

    BAckup online with include logs fails !!!

    Hi all,

    db2 9.1 fixpak 0
    aix 5.3

    I have a big problem every time I start an online backup with include logs via veritas comes out an error!!!
    The db2diag shows:
    2009-10-29-17.57.22.240269 +060 E10634592A396 LEVEL: Info
    PID : 995458 TID : 1 PROC : db2agent (idle)
    INSTANCE: db2inst1 NODE : 000 DB : ATMDB
    APPHDL : 0-692 APPID: *LOCAL.db2inst1 .091029165722
    AUTHID : DB2INST1...
    See more | Go to post
    • alex250374
      replied to Empty Table
      in DB2
      Hi Sanjay, Thanks for your response,
      the partitioning but I had already thought ... how do I partition it for days? and then, as I organize the process that empty table? I run the drop partitions for more than three days old and at the same time they create for the other days? I feel somewhat complex as a solution ......
      See more | Go to post

        Leave a comment:

      • alex250374
        replied to Empty Table
        in DB2
        thanks for your answer Doc Diesel,

        but I can not divide the table into 3 parts per requirements associated application that you access.

        there's another way ?...
        See more | Go to post

          Leave a comment:

        • alex250374
          started a topic Empty Table
          in DB2

          Empty Table

          Hello world,

          (excuse my English) I have to empty a daily a table that has 50,000,000 record and that stores data by "date". Whenever the empties must remain only the last 3 days of data.
          With DELETE
          (DELETE FROM SCHEMA.TABLE WHERE DATE(AGG_TIMEST AMP) < DATE(CURRENT TIMESTAMP) - 3 DAY;).
          The trasaction log are filled and delete fails. Trauncate the table can not be conditioned.

          how can...
          See more | Go to post
          • alex250374
            replied to Automate delete archive log !
            in DB2
            Hi docdiesel,

            thank you for your reply.

            My problem is this: I must set the DB for full online backup includes logs all day with VERITAS. I set LOGRETAIN = RECOVERY and USEREXIT = ON. Veritas makes backup without problem but does not erase the log achieved!
            So that the filesystem where there are logs will be filled very soon!!!

            How can I do? I do not know where most beat their heads!
            See more | Go to post

              Leave a comment:

            • alex250374
              started a topic Automate delete archive log !
              in DB2

              Automate delete archive log !

              I have a db is in archive mod (LOGRETAIN = RECOVERY) and logprimary is set to 3. Pat the log file is / arch_log. If I go in that path i have:
              S0000000.LOG
              S0000001.LOG
              S0000002.LOG
              S0000003.LOG
              S0000004.LOG
              S0000005.LOG
              S0000006.LOG

              But the active logs are only S0000004.LOG S0000005.LOG S0000006.LOG (db cfg >>> First active log file S0000004.LOG) ?
              Others can delete...
              See more | Go to post
              • alex250374
                replied to Backup Online db2 9.1
                in DB2
                Thanks for your answer,

                what interests me most is the operating parameters logprimary (3) and logsecond (2). How many log files are stored in total? After some time the file is filled and those older must move them by hand?
                See more | Go to post

                  Leave a comment:

                • alex250374
                  started a topic Backup Online db2 9.1
                  in DB2

                  Backup Online db2 9.1

                  Hello to all,

                  I do a backup of an online db and I changed from db cfg parameter logretain on recovery, then I made the backup full offline, what other parameters to be amended? especially I wonder how it should change the parameters logarchmeth1 / default 3)and 2 (default 2) and the path of arch logs so I created a special filesustem.

                  Thanks
                  See more | Go to post
                  • alex250374
                    started a topic Count the number of select on a particular table
                    in DB2

                    Count the number of select on a particular table

                    Hello to all,
                    are not practical and db2... I need urgent help:

                    how can count the number of select is done on a particular table in a certain period of time?
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...