Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Jan 2009
    Location
    Melbourne, Australia
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Smile Formatting DB and Log volumes

    Hi All,

    Server: Windows 2003
    TSM Version: 5.5.1.0

    Fresh install of TSM server, this is a test environment. All drives are local.

    DB volume is on E drive (e:\db1.dsm) and is 12,000MB
    Log volume is on L drive (l:\log1.dsm) and is 3,000MB

    What I want to do is change this so that I have two DB volumes and 2 log volumes on separate drives:

    DB volume 1: e:\db1.dsm (12,000mb)
    DB volume 2: f:\db2.dsm (12,000mb)

    Log volume 1: l:\log1.dsm (3,000mb)
    Log volume 2: m:\log2.dsm (3,000mb)

    I have shut down TSM via a halt command, and the "Server1" instance is not running. I go to a DOS prompt, and CD to the "Server1" directory:

    cd "\program files\tivoli\tsm\server\server1"

    Then I need to run the "dsmserv" command to format and create the new db/log files:

    ..\server\dsmserv -k server1 format 2 e:\db1.dsm 12000 f:\db2.dsm 12000 2 l:\log1.dsm 3000 m:\log2.dsm 3000

    Which means use the "server1" key in the registry, and format 2 db volumes of 12,000MB each, and also 2 log volumes, at 3000mb each all on different drives.

    When pressing enter, it appears to start, and then it simply tries to start the previous instance of TSM, rather than formatting any log and db volumes!

    I would normally expect it to say that it's formatting the db volumes and then the log volumes.... but I cannot get it to format anything.

    I have tried:
    * deleting the dsmserv.dsk file (doesn't help as it defines the disk/log files)
    * replacing the "format" command with "loadformat" (doesn't do anything different)

    Does anyone have any ideas? Essentially I want to blow the existing db/log volumes away (they are empty anyway) and then create them all again on different drives.

    Thanks in advance!

    Dave

  2. #2
    Moderator Harry_Redl's Avatar
    Join Date
    Dec 2003
    Location
    Czech Republic
    Posts
    2,203
    Thanks
    3
    Thanked 97 Times in 96 Posts

    Default

    Hi,

    command is OK ... is the registry key really "server1"?
    Just one thing - why do you do these things off-line? Use def dbvol (logvol) to create new volumes, then delete the old ones (one at a time) using del dbvol (logvol) and then extend the DB (log) to fill up the new space.

    Harry

    P.S. just for curiosity - can you post here the output of format attempt?

    Edit:
    This post resurfaced after long time and I noticed my post was incorrect - the command whiteone used was NOT correct - when using "dsmserv format" command, log files go first, db files second - so it was not right to create logfiles exceeding 12,5GB.
    Anyway - online extension is the best

    Harry
    Last edited by Harry_Redl; 09-26-2009 at 01:25 PM.

  3. #3
    Member
    Join Date
    Jan 2009
    Location
    Melbourne, Australia
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by Harry_Redl View Post
    Hi,

    command is OK ... is the registry key really "server1"?
    Just one thing - why do you do these things off-line? Use def dbvol (logvol) to create new volumes, then delete the old ones (one at a time) using del dbvol (logvol) and then extend the DB (log) to fill up the new space.

    Harry

    P.S. just for curiosity - can you post here the output of format attempt?
    Hi Harry,
    Thank you for your reply

    Yeah the registry key is "server1" as this is the first of a couple of instances to be installed to this server.

    I'm not sure why I haven't done the create/extend, I guess I just didn't think of it that way... But either way, I should be able to format and recreate db/log vols, which I seem to not to be able to do.

    Below is the output from the command:
    Code:
    C:\Program Files\Tivoli\TSM\Server\server>..\server\dsmserv -k server1 format 2 e:\db1.dsm 12000 f:\db2.dsm 12000 2 l:\log1.dsm 3000 m:\log2.dsm 3000[/SIZE][/FONT]
    
    ANR0900I Processing options file C:\Program Files\Tivoli\TSM\Server\server1\dsmserv.opt.
    ANR7800I DSMSERV generated at 08:35:01 on Jul 24 2008.
    
    Tivoli Storage Manager for Windows
    Version 5, Release 5, Level 1.0
    
    Licensed Materials - Property of IBM
    
    (C) Copyright IBM Corporation 1990, 2007.
    All rights reserved.
    U.S. Government Users Restricted Rights - Use, duplication or disclosure
    restricted by GSA ADP Schedule Contract with IBM Corporation.
    
    ANR4726I The ICC support module has been loaded.
    ANR0990I Server restart-recovery in progress.
    ANR0200I Recovery log assigned capacity is 8 megabytes.
    ANR0201I Database assigned capacity is 12 megabytes.
    ANR0306I Recovery log volume mount in progress.
    ANR0285I Database page shadowing started using file dbpgshdw.bdt.
    ANR0353I Recovery log analysis pass in progress.
    ANR0354I Recovery log redo pass in progress.
    ANR0355I Recovery log undo pass in progress.
    ANR0352I Transaction recovery complete.
    ANR1635I The server machine GUID, 65.46.41.41.d5.3c.11.dd.bc.9d.00.21.5e.26.7f.f4, has initialized.
    ANR2100I Activity log process has started.
    ANR4726I The NAS-NDMP support module has been loaded.
    ANR0984I Process 1 for EXPIRATION started in the BACKGROUND at 14:50:54.
    ANR2803I License manager started.
    ANR0811I Inventory client file expiration started as process 1.
    ANR2560I Schedule manager started.
    ANR8260I Named Pipes driver ready for connection with clients.
    ANR0993I Server initialization complete.
    ANR0812I Inventory file expiration process 1 completed: examined 0 objects,
    deleting 0 backup objects, 0 archive objects, 0 DB backup volumes, and 0
    recovery plan files. 0 errors were encountered.
    ANR0916I TIVOLI STORAGE MANAGER distributed by Tivoli is now ready for use.
    ANR8200I TCP/IP Version 4 driver ready for connection with clients on port 1500.
    ANR8280I HTTP driver ready for connection with clients on port 1580.
    ANR4747W The web administrative interface is no longer supported. Begin using
    the Integrated Solutions Console instead.
    ANR0985I Process 1 for EXPIRATION running in the BACKGROUND completed with
    completion state SUCCESS at 14:50:54.
    ANR0984I Process 2 for AUDIT LICENSE started in the BACKGROUND at 14:50:54.
    ANR2820I Automatic license audit started as process 2.
    ANR2825I License audit process 2 completed successfully - 0 nodes audited.
    ANR0985I Process 2 for AUDIT LICENSE running in the BACKGROUND completed with completion state SUCCESS at 14:50:54.
    TSM:TSMSERVER>
    Note the "assigned capacities". These values (8MB for one log volume and 12MB for one db volume) are from the previous "default" install that I did earlier before attempting this.

    Thanks Harry,

    Dave

Similar Threads

  1. rebuilding db, log, pool volumes
    By gernthefish in forum Restore / Recovery Discussion
    Replies: 3
    Last Post: 10-08-2008, 11:25 AM
  2. Moving data from defunct log and database volumes
    By Elomis in forum TSM Installation, Upgrade and Configuration
    Replies: 3
    Last Post: 10-17-2007, 04:10 AM
  3. DB and Log disk volumes
    By itcsge in forum TSM Server
    Replies: 5
    Last Post: 08-28-2007, 04:15 AM
  4. Formatting Select statements
    By JRTrimark in forum TSM Reporting & Monitoring
    Replies: 0
    Last Post: 12-01-2004, 06:58 PM
  5. Log mode switch when missing log volumes
    By stwe01 in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 07-24-2004, 11:16 PM

Tags for this Thread

Posting Permissions

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