Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    1

    Unanswered: dump striped devices

    Hi everyone,

    I'm working with Sybase 12.5.3 on AIX 5.x.

    I'm looking at some old scripts and see some of the databases have striped devices to dump and load.

    what commands gives info on striped devices?

    sp_helpdb or
    sp_helpdevice

    gives no information on this...

    Basically, if we want to know whether or not the system we have, running backups or loads on striped devices where we can find these info?


    Thanks a lot for your comments!

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    That info doesn't need to be in the database.
    Look at the dump script.
    It probably looks something like this.

    dump database pubs2 to "compress::/backups/pubs2_1of3.dgz"
    stripe on "compress::/backups/pubs2_2of3.dgz"
    stripe on "compress::/backups/pubs2_3of3.dgz"

Posting Permissions

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