Re: Antwort: Re: SQL-Backtrack and multiple tapes
Rolf Meyer [EMAIL PROTECTED] on 02/05/2001 01:48:11 AM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: George Lesho/Partners/AFC) Fax to: Subject: Antwort: Re: SQL-Backtrack and multiple tapes Steffan, I am new on the list but am familiar with SQL-BackTrack for Informix. I know this is a different product but it uses and OBSI module which specifies "ADSM" instead of tapes or drives. The "mount points" needed, thus, are not directly attibutable to the tape or drive resources available but seem to represent communication threads available. During testing, we found that sometimes backups would work with 1 mount point, they would work most of the time with 2 and work all the time with three. Hope this info is of some help. George Lesho Storage Admin AFC Enterprises Thema: Re: SQL-Backtrack and multiple tapes Rolf, update the client's registration parameter maximum number of mount points to 2. Steffan Rolf Meyer wrote: Hello I use TSM 4.1.2 on Solaris 8 with BMC SQL Backtrack for Oracle. Trying to do a backup of a 300G SAP DB using more than one backup stream. SQL-BT starts two sessions to TSM, one gets a tape from 3494 lib, other stays on MediaW. Both stream go to same Managementclass/Storage Pool. How should I configure TSM to let SQL-BT writing to more than one tape. Thanks for your help Rolf Meyer SATISFACTORY Info Business Systems GmbH 22607 Hamburg [EMAIL PROTECTED] -- Regards, Steffan Rhoads Principal SAN Architect Professional Services Inrange Technologies Corporation 714-731-5474 - Voice 877-681-2781 - 2-way Pager or [EMAIL PROTECTED] 714-832-9181 - Fax
Re: SQL-Backtrack and multiple tapes
Hallo thanks all for your help. Redefining the storagepool to filespace-based collocation and changes in the pool defs of SQL-BT has fixed the problem. Greetings from Hamburg Rolf Meyer SATISFACTORY Info Business Systems GmbH
Re: Antwort: Re: SQL-Backtrack and multiple tapes
Rolf What is your device class mount limit? If it isn't already set to drives you might want to set it to drives Becky Davidson Data Manager/AIX Administrator EDS/Earthgrains voice: 314-259-7589 fax: 314-877-8589 email: [EMAIL PROTECTED] -Original Message- From: Rolf Meyer [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:48 AM To: [EMAIL PROTECTED] Subject: Antwort: Re: SQL-Backtrack and multiple tapes Hello Steffan, client has max mount point of three, which is more as he needs. Is collocating no the right choice ? Greetings Rolf Meyer arhoads [EMAIL PROTECTED] am 02.02.2001 18:01:31 Bitte antworten an [EMAIL PROTECTED] An:[EMAIL PROTECTED] Kopie: (Blindkopie: Rolf Meyer/Satisfactory) Thema: Re: SQL-Backtrack and multiple tapes Rolf, update the client's registration parameter maximum number of mount points to 2. Steffan Rolf Meyer wrote: Hello I use TSM 4.1.2 on Solaris 8 with BMC SQL Backtrack for Oracle. Trying to do a backup of a 300G SAP DB using more than one backup stream. SQL-BT starts two sessions to TSM, one gets a tape from 3494 lib, other stays on MediaW. Both stream go to same Managementclass/Storage Pool. How should I configure TSM to let SQL-BT writing to more than one tape. Thanks for your help Rolf Meyer SATISFACTORY Info Business Systems GmbH 22607 Hamburg [EMAIL PROTECTED] -- Regards, Steffan Rhoads Principal SAN Architect Professional Services Inrange Technologies Corporation 714-731-5474 - Voice 877-681-2781 - 2-way Pager or [EMAIL PROTECTED] 714-832-9181 - Fax
Antwort: Re: Antwort: Re: SQL-Backtrack and multiple tapes
Hello Devclass mount limit is drives (we have four drives 3590E). Greetings Rolf "Davidson, Becky" [EMAIL PROTECTED] am 05.02.2001 09:08:41 Bitte antworten an "ADSM: Dist Stor Manager" [EMAIL PROTECTED] An:[EMAIL PROTECTED] Kopie: (Blindkopie: Rolf Meyer/Satisfactory) Thema: Re: Antwort: Re: SQL-Backtrack and multiple tapes Rolf What is your device class mount limit? If it isn't already set to drives you might want to set it to drives Becky Davidson Data Manager/AIX Administrator EDS/Earthgrains voice: 314-259-7589 fax: 314-877-8589 email: [EMAIL PROTECTED] -Original Message- From: Rolf Meyer [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:48 AM To: [EMAIL PROTECTED] Subject: Antwort: Re: SQL-Backtrack and multiple tapes Hello Steffan, client has max mount point of three, which is more as he needs. Is collocating no the right choice ? Greetings Rolf Meyer arhoads [EMAIL PROTECTED] am 02.02.2001 18:01:31 Bitte antworten an [EMAIL PROTECTED] An:[EMAIL PROTECTED] Kopie: (Blindkopie: Rolf Meyer/Satisfactory) Thema: Re: SQL-Backtrack and multiple tapes Rolf, update the client's registration parameter maximum number of mount points to 2. Steffan Rolf Meyer wrote: Hello I use TSM 4.1.2 on Solaris 8 with BMC SQL Backtrack for Oracle. Trying to do a backup of a 300G SAP DB using more than one backup stream. SQL-BT starts two sessions to TSM, one gets a tape from 3494 lib, other stays on MediaW. Both stream go to same Managementclass/Storage Pool. How should I configure TSM to let SQL-BT writing to more than one tape. Thanks for your help Rolf Meyer SATISFACTORY Info Business Systems GmbH 22607 Hamburg [EMAIL PROTECTED] -- Regards, Steffan Rhoads Principal SAN Architect Professional Services Inrange Technologies Corporation 714-731-5474 - Voice 877-681-2781 - 2-way Pager or [EMAIL PROTECTED] 714-832-9181 - Fax
Re: SQL-Backtrack and multiple tapes
I use TSM 4.1.2 on Solaris 8 with BMC SQL Backtrack for Oracle. Trying to do a backup of a 300G SAP DB using more than one backup stream. SQL-BT starts two sessions to TSM, one gets a tape from 3494 lib, other stays on MediaW. Both stream go to same Managementclass/Storage Pool. How should I configure TSM to let SQL-BT writing to more than one tape. We have done this successfully. We configured SQL-BackTrack so that it would use a different prefix for the filespace names created by each stream, and configured the TSM storage pool for collocation by filespace (as opposed to collocation by node).
Antwort: Re: SQL-Backtrack and multiple tapes
Hello Steffan, client has max mount point of three, which is more as he needs. Is collocating no the right choice ? Greetings Rolf Meyer arhoads [EMAIL PROTECTED] am 02.02.2001 18:01:31 Bitte antworten an [EMAIL PROTECTED] An:[EMAIL PROTECTED] Kopie: (Blindkopie: Rolf Meyer/Satisfactory) Thema: Re: SQL-Backtrack and multiple tapes Rolf, update the client's registration parameter maximum number of mount points to 2. Steffan Rolf Meyer wrote: Hello I use TSM 4.1.2 on Solaris 8 with BMC SQL Backtrack for Oracle. Trying to do a backup of a 300G SAP DB using more than one backup stream. SQL-BT starts two sessions to TSM, one gets a tape from 3494 lib, other stays on MediaW. Both stream go to same Managementclass/Storage Pool. How should I configure TSM to let SQL-BT writing to more than one tape. Thanks for your help Rolf Meyer SATISFACTORY Info Business Systems GmbH 22607 Hamburg [EMAIL PROTECTED] -- Regards, Steffan Rhoads Principal SAN Architect Professional Services Inrange Technologies Corporation 714-731-5474 - Voice 877-681-2781 - 2-way Pager or [EMAIL PROTECTED] 714-832-9181 - Fax
Re: SQL-Backtrack and multiple tapes
Rolf, update the client's registration parameter maximum number of mount points to 2. Steffan Rolf Meyer wrote: Hello I use TSM 4.1.2 on Solaris 8 with BMC SQL Backtrack for Oracle. Trying to do a backup of a 300G SAP DB using more than one backup stream. SQL-BT starts two sessions to TSM, one gets a tape from 3494 lib, other stays on MediaW. Both stream go to same Managementclass/Storage Pool. How should I configure TSM to let SQL-BT writing to more than one tape. Thanks for your help Rolf Meyer SATISFACTORY Info Business Systems GmbH 22607 Hamburg [EMAIL PROTECTED] -- Regards, Steffan Rhoads Principal SAN Architect Professional Services Inrange Technologies Corporation 714-731-5474 - Voice 877-681-2781 - 2-way Pager or [EMAIL PROTECTED] 714-832-9181 - Fax