Looked in the db2 manuals, didn't see what I wanted.
Tsm 6.2.5 under RHEL 6.1
Is there a way to trim trailing whitespace from string fields within a select
statement?
Looked at the trim function, but it didn't appear to be what I needed.
Thanks for the help.
Have you looked at rtrim?
-
Cameron Hanover
chano...@umich.edu
Our integrity sells for so little, but it is all we really have. It is the
very last inch of us, but within that inch, we are free.
--Valerie (V for Vendetta)
On Oct 2, 2014, at 10:29 AM, Lee, Gary g...@bsu.edu wrote:
Looked in
Rtrim did it.
Was looking in the wrong volume of the sql reference.
Thanks.
I have run myself ragged on this one.
I would have sworn it worked yesterday morning.
Tsm server 6.2.5 under RHEL 6.1
I am trying to get a list of nodes not in a collocgroup.
Statement follows:
Select a.node_name from nodes a where
a.node_name not in (select b.node_name from collocgroup b)
Hi,
It seems to work ok for me, I added a - for continuation. TSM on 6.3.0 on
AIX 7, and TSM 6.3.4 on Redhat 5 and 6
Select a.node_name from nodes a where -
a.node_name not in (select b.node_name from collocgroup b)
On Thu, Sep 11, 2014 at 5:51 AM, Lee, Gary g...@bsu.edu wrote:
I have run
[mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick
Marouf
Sent: Thursday, September 11, 2014 8:08 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] sql question
Hi,
It seems to work ok for me, I added a - for continuation. TSM on 6.3.0 on
AIX 7, and TSM 6.3.4 on Redhat 5 and 6
Select a.node_name
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick
Marouf
Sent: Thursday, September 11, 2014 8:08 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] sql question
Hi,
It seems to work ok for me, I added a - for continuation. TSM on 6.3.0 on
AIX
Sefranek
Sent: Thursday, September 11, 2014 8:56 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] sql question
Gary,
Since the field COLLOCGROUP_NAME is in the NODES table you could use the
below queries as a sanity check to help verify the results you are
seeing from your collocation sub-query
/Tivoli
+Storage+Manager/page/Home
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2014-09-11
09:01:03:
From: Lee, Gary g...@bsu.edu
To: ADSM-L@VM.MARIST.EDU
Date: 2014-09-11 09:01
Subject: Re: sql question
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
Thanks William.
Don't
@VM.MARIST.EDU
Subject: [ADSM-L] sql question
I have run myself ragged on this one.
I would have sworn it worked yesterday morning.
Tsm server 6.2.5 under RHEL 6.1
I am trying to get a list of nodes not in a collocgroup.
Statement follows:
Select a.node_name from nodes a where
a.node_name
:
From: Rick Adamson rickadam...@biloholdings.com
To: ADSM-L@vm.marist.edu
Date: 06/27/2014 04:05 PM
Subject: Re: TSM SQL question
Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
Del,
Is it just me or does the restore command in step two of this
article run off the page rather than
Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del
Hoobler
Sent: Monday, June 16, 2014 6:38 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM SQL question
Hi Mike,
Yes. This is possible. There are a number of customers doing it.
This might help you:
http://www-01.ibm.com/support
/2014
09:35:55 AM:
From: Michael P Hizny mhi...@binghamton.edu
To: ADSM-L@vm.marist.edu
Date: 06/13/2014 09:36 AM
Subject: TSM SQL question
Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
Hi,
We are trying to set up an automated refresh of our test system
databases
(Microsoft SQL
Hi,
We are trying to set up an automated refresh of our test system databases
(Microsoft SQL) using the TSM SQL client. Does anyone know if it is
possible to automatically do an SQL backup of a production server database
and then restore this to a test system server via a command line script?
Manager [mailto:ads...@vm.marist.edu] On Behalf Of Remco
Post
Sent: Thursday, October 29, 2009 4:37 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL question
On 29 okt 2009, at 22:24, Steven Harris wrote:
Try this
select count(volume_name), vu.node_name from volume_usage vu, nodes n
where
Management would like to know how many tapes are being used by each
domain(=administrative unit). Logically, I think the query should look like
this:
select count(volume_name),node_name from volumeusage where copy_type='BACKUP'
and not stgpool_name='OFFSITEPOOL' and node_name in (select
On 29 okt 2009, at 22:06, Fred Johanson wrote:
Management would like to know how many tapes are being used by each
domain(=administrative unit). Logically, I think the query should
look like this:
select count(volume_name),node_name from volumeusage where
copy_type='BACKUP' and not
Try this
select count(volume_name), vu.node_name from volume_usage vu, nodes n
where vu.node_name=n.node_name and copy_type='BACKUP' and stgpool_name
!= 'OFFSITEPPOOL' and n.domain_name='SYSSERV'
Regards
Steve Harris
Unemployed and Impoverished TSM Admin
Sydney Australia
Fred Johanson
On 29 okt 2009, at 22:24, Steven Harris wrote:
Try this
select count(volume_name), vu.node_name from volume_usage vu, nodes n
where vu.node_name=n.node_name and copy_type='BACKUP' and stgpool_name
!= 'OFFSITEPPOOL' and n.domain_name='SYSSERV'
...group by vu.node_name
Regards
Steve
i run:
SELECT activity, count(entity) as SESSIONS,
cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as GB FROM summary
where end_timecurrent_timestamp-48 hours GROUP BY activity
why is it that tape mount and expiration sessions are 0?
--
eric.wonder...@vt.edu
Systems Engineering and Admin
In working with table fields, you have to watch out for values which
can be null.
Change your count(entity) to count(*).
Richard Sims
I would like to set up a qurey for volumes in a storage pool which do not
contain data from a set of clients.
Or, if easier, a list of volumes in a pool which contain data from any of a set
of clients.
I have a script for doing this with a single client, but not sure about
expanding it to
@VM.MARIST.EDU
Subject: [ADSM-L] Sql question
I would like to set up a qurey for volumes in a storage pool which do
not contain data from a set of clients.
Or, if easier, a list of volumes in a pool which contain data from any
of a set of clients.
I have a script for doing this with a single client
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/22/2009
10:14:11 PM:
[image removed]
Re: TDP Sql question about log growing
Paul Dudley
to:
ADSM-L
01/22/2009 10:15 PM
Sent by:
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
Please
Hi to all
In a sever Windows 2003 with SQL database I saw that a log increase very much
( to +26 GB) , it was programmed with the option Recovery Model: Full
I run every day a full backup (not any log backup) with the command:
tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/22/2009
03:31:10 AM:
TDP Sql question about log growing
Robert Ouzen Ouzen
to:
ADSM-L
01/22/2009 03:32 AM
Sent by:
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
Please respond to ADSM: Dist Stor Manager
Hi
: Friday, 23 January 2009 1:38 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP Sql question about log growing
Robert,
You need to run a LOG backup in order to truncate the logs.
BTW, truncating the transaction log does not reduce the size of a
physical log file; it reduces only the size
... log command is for truncate=yes.
Best Regards,
Martin Panggabean |
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Paul
Dudley
Sent: Friday, January 23, 2009 10:14 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP Sql question about log
On Mon, 2 Jun 2008 14:58:06 -0400, Richard Rhodes [EMAIL PROTECTED] said:
I am thinking that you'll need to just get the raw columnar data for each
volume record, then feed it into another program
That's what I was beginning to think, and where I'll head.
Permit me to recommend 'sqlite'.
:To
Dist Stor ADSM-L@VM.MARIST.EDU
Manager cc
[EMAIL PROTECTED]
.EDU Subject
Re: yasq (yet another SQL question
I'm trying to get a handle around the compression ratio on our
3494 tapes. I'm trying to generate a table showing each
compression ratio and the number of volumes of that ratio.
All the tapes in the lib are 60gb. It should look simething
like this . . .
ratio count
- -
The problem is that unless est_capacity_mb matches exactly between
multiple volumes, the results of the from will return a single record
from the VOLUMES table consisting of the est_capacity_mb field and the
count (which is 1). After the math is done on the column to compute the
ratio, you have
Try without distinct
Goodl luck
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Rhodes
Sent: Monday, June 02, 2008 2:09 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] yasq (yet another SQL question)
I'm trying to get a handle around
I am thinking that you'll need to just get the raw columnar data for each
volume record, then feed it into another program
That's what I was beginning to think, and where I'll head.
Thanks!
Rick
-
The information contained in this message is intended
Clarification:
The first (long) sentence of my earlier response(below) should read:
The problem is that unless est_capacity_mb matches exactly between
multiple volumes, the results of the from will return a single record
from the VOLUMES table ***for each volume*** consisting of the
like 'NASPOOL_L4' group by est_capacity_mb
,volume_name
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Raibeck
Sent: Monday, June 02, 2008 2:43 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] yasq (yet another SQL question)
The problem
] On
Behalf Of Del Hoobler
Sent: Saturday, 4 August 2007 2:37 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL question
Paul,
Typically... I see that people will name their node
the same as their primary SQL node with an extension.
Something like:
Primary
Subject: Re: [ADSM-L] TDP for SQL question
Paul,
Typically... I see that people will name their node
the same as their primary SQL node with an extension.
Something like:
Primary: SQLSRV23_SQL
Archive: SQLSRV23_SQL_ARCH
And they will have a separate DSM.OPT file, something
Paul,
Typically... I see that people will name their node
the same as their primary SQL node with an extension.
Something like:
Primary: SQLSRV23_SQL
Archive: SQLSRV23_SQL_ARCH
And they will have a separate DSM.OPT file, something like
DSMARCH.OPT that has the archive
I have been told that if I want to create an archive backup of an SQL
database via TDP for SQL, then I should create a separate node name in
TSM (such as SQL_Archive) and then backup using that node name once a
month (for example) and make sure to bind those backups to a management
class that has
On 03/08/2007, at 2:53 PM, Paul Dudley wrote:
I have been told that if I want to create an archive backup of an
SQL
database via TDP for SQL, then I should create a separate node name in
TSM (such as SQL_Archive) and then backup using that node name
once a
month (for example) and make sure to
Firstly, i apologise for initially posting this without a subject line!
(untitled). So..
Hi,
I have an interesting TDP for SQL problem. Similar issues have been
addressed many times on the forum, but this is a bit different, i think.
I have:
Windows server running multiple (x2) SQL server
Jeff,
It looks like you forgot to specify the correct
option file on the launch of the GUI. You are specifying the
the correct SQL Server instance... but you also need to
tell Data Protecion for SQL what TSM API options file to use
(which tells it which NODENAME to use):
For instance 1:
Re: yasq (yet another sql question
. . . . )
01/19/2005 03:19
AM
Please respond to
ADSM: Dist Stor
Manager
Hi.
Think the problem is in TSM!
Se my examples:
FIRST I run
Hi Everyone . . .
I'm trying to do a couple things . . . .
1) Trying to get a listing as follows, where the occupancy filespace
stats are sum'ed for each node, with the node domain thrown in:
like this: node domain sum-files sum-physicalMB sum-logicalMB
Here is the command I'm trying
Well, if you connected to TSM via ACCESS, it would look like this:
SELECT DISTINCTROW OCCUPANCY.STGPOOL_NAME, Sum(OCCUPANCY.NUM_FILES) AS
[Sum Of NUM_FILES], Sum(OCCUPANCY.PHYSICAL_MB) AS [Sum Of PHYSICAL_MB],
Sum(OCCUPANCY.LOGICAL_MB) AS [Sum Of LOGICAL_MB], Count(*) AS [Count Of
OCCUPANCY] FROM
I don't think it is an SQL question. The SELECT works just fine as is
when I run it as a TSM script.
I think your problem is something to do with extraneous characters,
character set, or with stdin on the host, not with TSM SQL.
-Original Message-
From: ADSM: Dist Stor Manager [mailto
.
Prather, Wanda
[EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU
HUAPL.EDU cc: (bcc: Eivind Birkeland)
Sent by: ADSM: Subject: Re: yasq (yet another
sql question . . . . )
Dist Stor
If we do a full database backup on sql server, then a log backup hourly,
would we need to do a differential backup and why?
Kevin M. Lipscomb/Michael Lovern
Dan River Inc.
Systems Engineering
Hi guys,
i've a little problem. I'm trying to install one MS SQL TDP and it doesn't
work. The installer talk to me that, this platform is not supported.
I'm on Win 2003, TDP is V5.2.1 ... What i don't understand is that in
readme is that TDP and MS SQL Server may not be installed on the same
Hello Peter,
There are two packages for Data Protection for SQL.
There is a 32-bit package and a 64-bit package.
Are you trying to install the 32-bit package on a
64-bit machine or the 64-bit package on a 32-bit machine?
There is installation code to protect against this,
which is most likely
:55 PM
To: [EMAIL PROTECTED]
Subject: Re: TDP SQL question
Robert,
You will need to add the /RECOVery=No option
to the restore of the full. If your physical environment
on the target system does not match the original system,
you may also have to use the /RELOCATE= and /TO= options.
Thanks
parameter ?
Regards Robert
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del
Hoobler
Sent: Tuesday, March 23, 2004 2:58 PM
To: [EMAIL PROTECTED]
Subject: Re: TDP SQL question
Robert,
No. This is not correct.
You still need to restore the log
Robert,
You do not need a SLEEP statement between the
two separate Data Protection for SQL commands.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 03/23/2004
08:02:39 AM:
Hi
Hi to all
I created a batch file to restore a database object and my question if is a
way to run it in one command the full and log for this database object.
Here my command line for full and log restore :
Full:tdpsqlc restore Campus full /fromsqlserver=highlearn
/tsmnode=highlearnk
Robert,
You will need to add the /RECOVery=No option
to the restore of the full. If your physical environment
on the target system does not match the original system,
you may also have to use the /RELOCATE= and /TO= options.
Thanks,
Del
the log ..
Thank you for your response ...
Regards Robert
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del
Hoobler
Sent: Monday, March 22, 2004 7:55 PM
To: [EMAIL PROTECTED]
Subject: Re: TDP SQL question
Robert,
You will need to add
Eric,
I would have them check again to make sure they
are using the NODENAME they think they are using.
Have them check their DP for SQL logs files as well.
Also, check the TSM Server activity log to see
what messages are being logged for that NODENAME.
DP for SQL will log ending statistics that
Hi *SM-ers!
I have got two TDP for SQL 2.2 clients. On one of them I see two filespaces:
Nodename\meta\
Nodename\data\
Both filespaces have a backup date 1, so that seems ok. The other node
however has both filespaces listed with a backup date of 31 days ago. So I
was thinking that the
We have a situation where we are trying setup a test SQL database on
a server.
The server (WinNT4 w/TSM client 3.7.2 and SQL client 1.1.2 and
MS-SQL 6.5) itself is cramped for space and we need to make a copy of the
database so that we can do some testing and still keep the
Now the question, can we tell the TDP client to do a restore of the
production database but then redirect it to another server running SQL?
We
have a spare server that has plenty of space that can be used for this.
If you are using TDP for SQL 1.1.2, refer to the TDP for SQL 1.1.2
Walters [EMAIL PROTECTED] on 06/06/2001 03:46:10 PM
Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSEG)
Subject: TSM on OS/390 and SQL Question.
I'm running TSM on OS/390 2.9. When i do an SQL in a batch job, I want to use
but by running it
together it does!
Al
-=-Original Message-
-=From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
-=Sent: Wednesday, June 06, 2001 10:46 AM
-=To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
-=Subject: TSM on OS/390 and SQL Question.
-=
-=
-=From: [EMAIL PROTECTED]
-=To: [EMAIL PROTECTED
We are looking into starting to use TDP for SQL. Question from our DBA's:
When configuring the SQL Server backups is it possible to configure a backup
that will backup ALL the SQL Server databases (master, msdb, and user
created) with one command such that if additional databases are added
into starting to use TDP for SQL. Question from our DBA's:
When configuring the SQL Server backups is it possible to configure a backup
that will backup ALL the SQL Server databases (master, msdb, and user
created) with one command such that if additional databases are added to SQL
Server
To: [EMAIL PROTECTED]
curtis.magura cc:
@LMCO.COM Subject: TDP for SQL Question
Sent by:
ADSM: Dist
Stor Manager
[EMAIL PROTECTED
PROTECTED]
cc:
Subject: Re: TDP for SQL Question
Yes, by default that is the way it is done. After you install TDP on the
client, look in the ..Tivoli/TSM/Mssql directory. The file sqlfull.smp is
designed to be copied to sqlfull.cmd. You need to edit the bat file for
directories etc. The backup
Hello!
Any SQL-experts out there?
I have no experience with sql except from the few things I have learned
from the tsm-implementation.
I want to query the events-table for avents for, lets say the last 24
hours.
Just like with the q events, only entries since today 00:00 are displayed
as
scheduled_start'08/01/2000' and
scheduled_start'08/31/2000'
James Thompson
From: Tom Tann{s [EMAIL PROTECTED]
Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: TSM-SQL-question..
Date: Fri, 1 Dec 2000 17:59:17 +0100
Hello!
Any SQL-experts out t
interface at
the web site?
Thanks,
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
-Original Message-
From: Tom Tann{s [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 10:09 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM-SQL-question..
Yes, I know. T
ann{s [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 10:09 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM-SQL-question..
Yes, I know. This is similar to my example.
However, I want to something similar to q event begint=now-24, which is a
generic thing, rather than using the actual d
71 matches
Mail list logo