Trying to run the reduce max to get space back in my database per technote
https://www-01.ibm.com/support/docview.wss?uid=swg21992410. When I try to
run the DB2 ALTER TABLESPACE it returns that it's an invalid command. How do
I run this on Windows2012 and TSM V7.1.7?
TIA,
Bill
@VM.MARIST.EDU
Onderwerp: Re: [ADSM-L] DB2 back-up issues on Windows
Karel
In my previous role I had a couple of TPC (now known as "Spectrum Control")
database servers running DB2 under windows with exactly this problem.
They ran for years without issue then started being unable to find dsm.op
Karel
In my previous role I had a couple of TPC (now known as "Spectrum Control")
database servers running DB2 under windows with exactly this problem.
They ran for years without issue then started being unable to find dsm.opt 10
or so days after a reboot.
Never did get to the bot
Yeah, but don't you think that would be allways the case and not after some
time Restart DB2, backup runs again (no change to any config item)
and after X amount of time errors start again.
Btw, its a windows system and DB2 runs under local admin account so default
permissions are always
I have found that most all of the "cannot find, or cannot read" I run into are
ultimately permission related, especially with DB2.
-Rick
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Karel
Bos
Sent: Thursday, February 02, 20
Hi,
Every day I have to restart DB2 (sometimes multiple times) due to backups
stop working. The DB2 database is doing log file and normal backups to TSM
and the backups stop working after the following couple of errors:
31.01.2017 10:48:04 instrStart: Unable to get write file lock or report
st Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul
van Dongen
Sent: Wednesday, September 14, 2016 9:58 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
tsmdb1 is the database name; the instance name should be the username under
whic
tsmdb1 is the database name; the instance name should be the username under
which the TSM server instance runs. When there are multiple TSM server
instances on the same AIX box, all databases are named "tsmdb1", each under his
own DB2 instance.
Met vriendelijke groet / With kind reg
Our TSM instance resides on a separate lun from AIX. We try not to add
filesystems to rootvg, for the most part. I keep all our TSM and db2 setup in
a filesystem tree called /tsmdata. Here is what it looks like for this system:
/dev/tsmdata0.06 0.061%6 1
] *EXTERNAL* Re: tsm/db2 won't start after boot drive
crash/recovery
Thanks!
I added the lines to /etc/services, and tried db2start, and db2 came up.
When I run db2iupdt I get:
rssymapi2p:/home/root==>/opt/tivoli/tsm/db2/instance/db2iupdt tsmdb1
DBI1446I The db2iupdt command is running.
TSM came up!
Of the steps below, I added the entries to /etc/services and ran the db2set
cmd. The db2iupdt failed.
But TSM/DB2 came up!
rssymapi2p:/tsmdata/tsmoc/config==>./rc.start_tsm_in_forground.ksh
ANR7800I DSMSERV generated at 17:06:42 on Jan 24 2016.
IBM Tivoli Storage Mana
Thanks!
I added the lines to /etc/services, and tried db2start, and db2 came up.
When I run db2iupdt I get:
rssymapi2p:/home/root==>/opt/tivoli/tsm/db2/instance/db2iupdt tsmdb1
DBI1446I The db2iupdt command is running.
DB2 installation is being initialized.
The specified insta
Seems to be an issue with the DB2 global registry.
To see the content of the registry:
db2greg -dump
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Rhodes, Richard L.
Sent: mercredi 14 septembre 2016 14:20
To: ADSM-L@VM.MARIST.EDU
Subject: Re
. /etc/services must contain:
DB2_ 60016/tcp
DB2__160017/tcp
DB2__260018/tcp
DB2__END 60019/tcp
Ports can vary, but must be in sequence
3. Instance "update": /opt/tivoli/tsm/db2/instance/db2iupdt
4. As instance owner: ~/sqllib/adm/db2set -g DB2SYSTEM=
5. dsm.sys for DBb
I found a db2nodes.cfg in the sqllib dir.
The sqllib dir is NOT on rootvg so it wasn't lost.
rssymapi2p:/tsmdata/tsmoc/config/sqllib==>cat db2nodes.cfg
0 rssymapi2p 0
The instance was a fully good/running TSM/DB2 system, although all it ever did
was run the OC hub.
For example, I fo
No, DB2 won't start at all.
rssymapi2p:/tsmdata/tsmoc/config==>db2start
SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11".
I'm not sure how to state this, but I think there is some configuration in DB2
(that would be in on the boot drive)
/docview.wss?uid=swg1IC67141
Kind regards,
Eric van Loon
Air France/KLM Storage Engineering
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Rhodes, Richard L.
Sent: dinsdag 13 september 2016 21:29
To: ADSM-L@VM.MARIST.EDU
Subject: tsm/db2 won't start
Was db2 running for sure?
In previous installs I had to modify the startup script to do a db2start then
sleep for 10 secs to get tsm to start correctly fron reboot of the system.
This was under redhat linux 6.
That was the message I would get.
-Original Message-
From: ADSM: Dist Stor
a mksysb from a partner lpar which
had the same AIX version and application version, but NOT TSM. So the lpar got
back up and running quickly - only took an hour, but it's missing the TSM
install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems
(data, logs, sqllib, etc) exist
"ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 04/26/2016
06:55:50 AM:
> From: Krzysztof Przygoda <przy...@gmail.com>
> To: ADSM-L@VM.MARIST.EDU
> Date: 04/26/2016 06:56 AM
> Subject: Re: Manual db2 online reorg for ver.6.3
&
..@us.ibm.com>:
> In
>http://www-01.ibm.com/support/docview.wss?uid=swg21683633#online_index
> IBM was trying to discuss the improvements that have been made to the on
> line index reorganization initiated by the Spectrum Protect server. It was
> not IBM's intention to recomm
In
http://www-01.ibm.com/support/docview.wss?uid=swg21683633#online_index
IBM was trying to discuss the improvements that have been made to the on
line index reorganization initiated by the Spectrum Protect server. It was
not IBM's intention to recommend that the above DB2 commands
ated to ver 7.1
> http://www-01.ibm.com/support/docview.wss?uid=swg21683633
>
> "*Online index reorganization*
>
> You can initiate online index reorganization by running a command with the
> following syntax:
> db2 reorg indexes all for table allow write access
>
>
Hi
Just wondering if anyone tried with TSM ver 6.3 method described in
document related to ver 7.1
http://www-01.ibm.com/support/docview.wss?uid=swg21683633
"*Online index reorganization*
You can initiate online index reorganization by running a command with the
following syntax:
db2
the health of the communities we serve.
From: ADSM: Dist Stor Manager [ADSM-L@VM.MARIST.EDU] on behalf of Rhodes,
Richard L. [rrho...@firstenergycorp.com]
Sent: Monday, January 25, 2016 12:53 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] DB2 active and mirror
Hello all
> >
> > Running a pair of TSM 7.1.3 servers here, and use Nagios to monitor our
> > environment.
> >
> > One of the service checks I run watches the number of DB2 users on the
> TSM
> > database. We see an rise and fall of user connections, and they
> On 26 jan. 2016, at 23:37, Ryder, Michael S <michael_s.ry...@roche.com> wrote:
>
> Hello all
>
> Running a pair of TSM 7.1.3 servers here, and use Nagios to monitor our
> environment.
>
> One of the service checks I run watches the number of DB2 users on the T
Hello all
Running a pair of TSM 7.1.3 servers here, and use Nagios to monitor our
environment.
One of the service checks I run watches the number of DB2 users on the TSM
database. We see an rise and fall of user connections, and they are all
consistently from one user...
"dsmserv"
D
HLOGDirectory /tsmdata/tsmsap2/db2archivelog
archfailoverlogdir/DD/tsmsap2/db2failoverlog
==> Filesystem info for DB2 logs:
df -g
Filesystem GB blocks Free %UsedIused %Iused Mounted on
/dev/db2activelog1 31.25 6.74 79% 55 1%
/tsmdata/tsmsap2/db2act
status reorg
ANR0336I,ANR0337I – db2 runstats process status
e.g.
q act msg="0293" begind=-15 endd=today
and so on...
Then, after each reorg, you will get some free pages which you can realse
to system by db2 alter tablespace reduce commands.
Good luck.
Krzysztof
2015-11-18 13:32 GMT+01
Maybe the space can only be released to the OS as soon as a DB2 reorg has
finished for the tables in question, I don't know. In that case it could take
up to 20 days before the space can be released...
Kind regards,
Eric van Loon
AF/KLM Storage Engineering
-Original Message-
From: ADSM
want to know that TSM/DB2
will reuse the space. Instead, overall db size just keeps
increasing!!! As you can see below, the db keeps
growing some number of MB per day.
(from a q db)
tsm FileSysMB UsedMB FreeMB date
tsm8 1126400 700615 425785 201501
tsm8 1126400 700709 425691
@VM.MARIST.EDU] On Behalf Of
Rhodes, Richard L.
Sent: dinsdag 17 november 2015 16:55
To: ADSM-L@VM.MARIST.EDU
Subject: Does a DB2 db ever shrink?
Hi,
On one of our TSM v6.3.5 databases we deleted two nodes which totaled 65m
files. After doing this we haven't seen any shrinkage in the database size
015436456172702185
The free db2 blocks (today) is 12,944.
By deleting the two nodes we dropped the number files by 65m files. But the
database itself hasn't changed in size (filesystem size) or free blocks inside
the db. The db2 is set to auto-reorg (the default).
Q) Why wouldn't our
The TSM database is not restored via DB2 commands. Instead, you should
restore it using the "dsmserv restore db" command. This is described in
the "TSM Administrator's Guide" for TSM V6, Chapter 33. The exact syntax
is in "TSM Administrator's Reference", Chapter
latest recorded state.
Op 14 okt. 2015 18:51 schreef "Roger Deschner" <rog...@uic.edu>:
> The TSM database is not restored via DB2 commands. Instead, you should
> restore it using the "dsmserv restore db" command. This is described in
> the "TSM Admin
Hello everyone
please someone help me, I look for the way to restore the database TSM V6
with "DB2 restore" command from a band (TAPE)
Any idea on the DB2 restore syntax?
--
: Dist Stor Manager [mailto:ADSM-L@vm.marist.edu] On Behalf Of Hans
Christian Riksheim
Sent: Tuesday, July 28, 2015 9:13 AM
To: ADSM-L@vm.marist.edu
Subject: [ADSM-L] Size of dedup tables in DB2
I would like to calculate the savings of doing dedup. DB2 runs on expensive
flash, the dedup pool on cheap
I would like to calculate the savings of doing dedup. DB2 runs on expensive
flash, the dedup pool on cheap SATA.
Anyone know how to calculate the extra amount of DB space caused by
deduplication?
Regards,
Hans Chr.
Sent: Tuesday, July 28, 2015 9:13 AM
To: ADSM-L@vm.marist.edu
Subject: [ADSM-L] Size of dedup tables in DB2
I would like to calculate the savings of doing dedup. DB2 runs on
expensive flash, the dedup pool on cheap SATA.
Anyone know how to calculate the extra amount of DB space caused
-Original Message- From: ADSM: Dist Stor Manager
[mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent:
Sunday, March 08, 2015 5:19 PM To: ADSM-L@VM.MARIST.EDU Subject:
Re: [ADSM-L] DB2/Oracle backup reporting and scheduling
Rick, It's a problem, everywhere, no matter how you do
, 2015 5:19 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] DB2/Oracle backup reporting and scheduling
Rick,
It's a problem, everywhere, no matter how you do it.
* The simplistic answer to your question is yes; the external scheduler
is running a list of tasks; after the last task
'
expected timestamp, close the file, sleep 10 minutes, rinse and repeat.
* However, even if you get one of those methods to work, it won't solve
the problem. I don't know about DB2, but unless something has changed recently
the only result you will get back from firing off the Oracle TDP
We have the same scenario. Oracle, db2 and MSSQL clients all prefer to do
their own backups.
It comes down to accountability. If they want to run their own backups
then THEY are responsible for reporting on them.
Maybe a harsh stance, but if I can't schedule it I will not report
] On Behalf Of Rick
Adamson
Sent: Friday, March 06, 2015 1:38 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: DB2/Oracle backup reporting and scheduling
Rick,
This all began after a recent audit revealed many systems either had missed
backup schedules, excessive retention, or no backups at all, which led
I assume someone has dealt with this I would like to hear how they handled it.
The issue:
DB2 and/or Oracle database backups that are dependent on completion of external
processes.
Currently our DBA's utilize a variety of methods to initiate DB2 and Oracle
database backups (CRON, external
] On Behalf Of Rick
Adamson
Sent: Friday, March 06, 2015 12:12 PM
To: ADSM-L@VM.MARIST.EDU
Subject: DB2/Oracle backup reporting and scheduling
I assume someone has dealt with this I would like to hear how they handled it.
The issue:
DB2 and/or Oracle database backups that are dependent on completion
: Friday, March 06, 2015 12:37 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] DB2/Oracle backup reporting and scheduling
Our Oracle backups have three scenarios.
1) Home grown scripts are scheduled via cron on the Oracle server,
copy/compress the db to local disk, then pushed the db backup
Rick,
ask L1/L2 about how to make db2 on aix use tcpip to communicate with dsmserv.
aix has a problem doing the massive amount of ipc processing which db2
generates.
I learned of this recently when the rhel 6.6 kernel bug bit us.
The switch to tcpip is available on all platforms. TSM will run
I worked with IBM on this problem.
We had 2 issues.
1) A bug in v6.3.5 that caused the start script rc.dsmserv to not use the
right memory limits. Solved by adding a line to the script.
2) AIX needed up graded to support the db2 version in v6.3.5.May I just
say that the DB2 page about
'
Subject: RE: FW: v6.3.5 hung db2??
If you are curious, here are the first of the nasty msgs that started the march
toward the crash yesterday.
I really like the msgs . . . database in evaluation mode.
02/15/15 12:45:35 ANR0106E cscmdsch.c(555): Unexpected error 4522
fetching row in table
@VM.MARIST.EDU] On Behalf Of
DeGroat, Steve
Sent: Monday, February 16, 2015 8:15 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: FW: v6.3.5 hung db2??
Thanks for these updates. We were looking to upgrade from v6.3.4 to v6.3.5
shortly, but will hold off for now. Please keep us posted with your progress.
Steve
[mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Mitchell, Ruth Slovik
Sent: Friday, February 13, 2015 3:13 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: FW: v6.3.5 hung db2??
Rick,
Thank you for letting us know about this. It would be interesting to know if
related messages were captured
it, they will come.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@vm.marist.edu] On Behalf Of
Rhodes, Richard L.
Sent: Monday, February 16, 2015 8:01 AM
To: ADSM-L@vm.marist.edu
Subject: Re: [ADSM-L] FW: v6.3.5 hung db2??
Well, I thought we had this resolved.
Yesterday (Sunday) we
Two days ago we upgrade one of our TSM instances to v6.3.5 (from v6.3.4).
This is our first v6.3.5 instance. It runs on a AIX server.
Last night at 19:32 it looks like DB2 went into some kind of a loop.
The instance became unresponsive. Dsmadmc cmds hung (didn't error, just hung).
Dsmserv
, Richard L.
Sent: Friday, February 13, 2015 9:49 AM
To: adsm-l mailing list (ADSM-L@VM.MARIST.EDU)
Subject: v6.3.5 hung db2??
Two days ago we upgrade one of our TSM instances to v6.3.5 (from v6.3.4).
This is our first v6.3.5 instance. It runs on a AIX server.
Last night at 19:32 it looks like DB2
/wikis/home/wiki/Tivoli%20Storage%20Manager
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2015-02-13
10:41:55:
From: Rhodes, Richard L. rrho...@firstenergycorp.com
To: ADSM-L@VM.MARIST.EDU
Date: 2015-02-13 10:44
Subject: FW: v6.3.5 hung db2??
Sent by: ADSM: Dist Stor Manager ADSM-L
Yea. I opened a Sev 1.
Thanks!
Rick
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Andrew
Raibeck
Sent: Friday, February 13, 2015 10:57 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: FW: v6.3.5 hung db2??
Hi Rick,
Off-hand I am not sure
Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Andrew Raibeck
Sent: Friday, February 13, 2015 10:57 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: FW: v6.3.5 hung db2??
Hi Rick,
Off-hand I am not sure what the problem is, I think it would be a good idea
to open a PMR if you have not already done
@VM.MARIST.EDU
Subject: Re: FW: v6.3.5 hung db2??
Hi Rick,
Off-hand I am not sure what the problem is, I think it would be a good
idea
to open a PMR if you have not already done so.
Best regards,
- Andy
Working with some good support folks!
Looks like we hit this:
http://www-01.ibm.com/support/docview.wss?crawler=1uid=swg1IT06126
The v6.3.5 and v7.1.0 caused a bug in the rc.dsmserv startup script. The
result is that db2 was running on limited memory - 32MB in our case
] On Behalf Of
Rhodes, Richard L.
Sent: Friday, February 13, 2015 1:38 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] FW: v6.3.5 hung db2??
Working with some good support folks!
Looks like we hit this:
http://www-01.ibm.com/support/docview.wss?crawler=1uid=swg1IT06126
The v6.3.5 and v7.1.0
Specialist - Operations
PotashCorp
T: (306) 933-8921
www.potashcorp.com
From: Thomas Denier thomas.den...@jefferson.edu
To: ADSM-L@VM.MARIST.EDU
Date: 01/09/2015 02:25 PM
Subject:[ADSM-L] DB2 LOCKLIST parameter
Sent by:ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
Inventory expiration processes on one of our TSM servers have been failing
occasionally with no obvious explanation. We were able to get trace data for
the most recent failure. IBM reviewed the trace data and advised us to increase
the DB2 LOCKLIST parameter. They referred us to a technote
Hello Wanda,
2008 ist not supported anymore. Only 2008 R2 is supported with tsm 7.1.1!
with best regards
stefan savoric
TSM 6.3.4 on Win2K8 64
Trying to run the upgrade to 7.1.1, the package fails after uninstalling 6.3.4
and DB2 and fails during the DB2 install.
Message:
ANRI1020E The DB2 installation failed. To review errors and correct any issues,
review C:\ProgramData\IBM\Installation
Manager\logs\native
Hi All,
During our morning DB2 reorg window, I've been observing a table reorg of the
BACKUP_OBJECTS table using the command db2pd -d TSMDB1 -reorg. It starts and
later pauses without appearing to do any work. I'm assuming this because
'CURCOUNT' is not incrementing, and remains at '0
Hi all,
Just wanted to direct your attention to this blog entry by Josh-Daniel Davis if
you are using TSM 7.1 in a large dedupped environment:
http://omnitech.net/reference/2014/08/04/db2-10-5-0-1-negative-colcard
We had a backup system in flames and 2 severity 1 PMRs open for more than 6
: [ADSM-L] Possible performance issue with TSM 7.1.0.x / DB2 10.5.x in
large dedup environment
Hi all,
Just wanted to direct your attention to this blog entry by Josh-Daniel Davis if
you are using TSM 7.1 in a large dedupped environment:
http://omnitech.net/reference/2014/08/04/db2-10-5-0-1
/docview.wss?uid=swg27021413
On 24 avril 2014 13:12:50 CEST, Remco Post r.p...@plcs.nl wrote:
Hi all,
I'm working on a simple excel for billing purposes (as a first step).
I've installed the DB2 Data server driver ODBC (and CLI) package. And
have managed to configure both a user DSN and a file DSN
=swg27021413
On 24 avril 2014 13:12:50 CEST, Remco Post r.p...@plcs.nl wrote:
Hi all,
I'm working on a simple excel for billing purposes (as a first step).
I've installed the DB2 Data server driver ODBC (and CLI) package. And
have managed to configure both a user DSN and a file DSN
Hi all,
I'm working on a simple excel for billing purposes (as a first step). I've
installed the DB2 Data server driver ODBC (and CLI) package. And have managed
to configure both a user DSN and a file DSN, but not a system DSN, which is
what I prefer, because other people will have to be able
[mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco
Post
Sent: Thursday, April 24, 2014 7:13 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] db2 odbc
Hi all,
I'm working on a simple excel for billing purposes (as a first step). I've
installed the DB2 Data server driver ODBC (and CLI) package. And have
Is there any way to force reinstall of DB2 for TSM 6.3.4 on AIX? Running the
install.bin doesn't seem to reinstall it on the system.
Thanks,
Kevin
You can do it outside of the standard TSM installer, by navigating to
extract directory/COI/PackageSteps/DB2/FILES/ESE/IMAGE
NOTE: extract directory is when you extracted the software to
install
Example: F:\mydownload\COI\PackageSteps\DB2\FILES\ESE\images
Then you can run setup.exe
Is ESE, CLIENT, and RTCL required?
Lee Miller lwmil...@us.ibm.com 4/18/2014 11:12 AM
You can do it outside of the standard TSM installer, by navigating to
extract directory/COI/PackageSteps/DB2/FILES/ESE/IMAGE
NOTE: extract directory is when you extracted the software to
install
Subject:Re: [ADSM-L] TSM DB2 reinstall
Sent by:ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
Is ESE, CLIENT, and RTCL required?
Lee Miller lwmil...@us.ibm.com 4/18/2014 11:12 AM
You can do it outside of the standard TSM installer, by navigating to
extract directory/COI
PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Moving the TSM DB2 database (AIX)
That is what I'm leaning towards as well. I've got NetApp looking at the disk
end to see if its getting hit hard. I also want to find out if the work load is
heavier on reads or write (I'm guessing read) to know
on Netapp - both v5 v6 - I had to do frequent netapp
'reallocate' commands to get the physical order in the netapp to match
the logical order of db2.
The db2 backup is reading the database sequentially, but within the netapp it
is completely out of order.
Try doing ' wafl scan measure_layout
795.65
Good Luck!
Bill Colwell
Draper Lab
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Kevin
Kettner
Sent: Thursday, March 27, 2014 12:34 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Moving the TSM DB2 database (AIX)
Thanks a ton for that info
!
On 3/21/2014 15:42, Prather, Wanda wrote:
Was just thinking the same -
It's only the conversion from V5 to V6 that takes forever. Once you are
V6/DB2, DB backup-restore is fast again.
I have TSM 6.3.4 on Windows, DB is 930G used, DS3512 disk, and it will back up
to LTO5 in 90 minutes
[mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Kevin
Kettner
Sent: Wednesday, March 26, 2014 8:34 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Moving the TSM DB2 database (AIX)
On the original question, I have moved DBs on AIX with LVM several times
with good success. The only real concern is the performance impact
] On Behalf Of Kevin
Kettner
Sent: Wednesday, March 26, 2014 11:34 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Moving the TSM DB2 database (AIX)
On the original question, I have moved DBs on AIX with LVM several times
with good success. The only real concern is the performance impact. The
benefit
and could not take the thru put of 3592 on really big items.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Kevin
Kettner
Sent: Wednesday, March 26, 2014 8:34 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Moving the TSM DB2 database (AIX
, 2014 11:34 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Moving the TSM DB2 database (AIX)
On the original question, I have moved DBs on AIX with LVM several times
with good success. The only real concern is the performance impact. The
benefit over mirroring is you can do it with no outage
: Moving the TSM DB2 database (AIX)
That is what I'm leaning towards as well. I've got NetApp looking at the
disk end to see if its getting hit hard. I also want to find out if the
work load is heavier on reads or write (I'm guessing read) to know what
sort of hardware fix is best for this, cache
When I had TSM databases on Netapp - both v5 v6 - I had to do frequent netapp
'reallocate' commands to get the physical order in the netapp to match
the logical order of db2.
The db2 backup is reading the database sequentially, but within the netapp it
is completely out of order.
Try doing
Thanks, I will investigate that a bit. Sounds plausible.
On 3/26/2014 13:04, Colwell, William F. wrote:
When I had TSM databases on Netapp - both v5 v6 - I had to do frequent netapp
'reallocate' commands to get the physical order in the netapp to match
the logical order of db2.
The db2
1:24 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Moving the TSM DB2 database (AIX)
That is what I'm leaning towards as well. I've got NetApp looking at the disk
end to see if its getting hit hard. I also want to find out if the work load is
heavier on reads or write (I'm guessing read
2014, Prather, Wanda wrote:
Was just thinking the same -
It's only the conversion from V5 to V6 that takes forever. Once you are
V6/DB2, DB backup-restore is fast again.
I have TSM 6.3.4 on Windows, DB is 930G used, DS3512 disk, and it will back up
to LTO5 in 90 minutes if the server isn't doing
On Saturday 22 March 2014 08:55:08 you wrote:
Thanks to all. AIX migraepv is the make/break mirror method. We will
probably proceed that way during the relative calm of Spring Break.
I prefer mirror / unmirror.
If you mirror the vg without background sync, you can start the sync manually
with
:00)
To: ADSM-L@VM.MARIST.EDU
Subject: Moving the TSM DB2 database (AIX)
Now that TSM V5 is gone from our shop and we're all TSM V6.2, it's time
to move some things around. Such as the TSM DB2 database. The manual
says to do a full database backup and restore. That could take days of
downtime
: Thursday, March 20, 2014 11:35 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Moving the TSM DB2 database (AIX)
Now that TSM V5 is gone from our shop and we're all TSM V6.2, it's time
to move some things around. Such as the TSM DB2 database. The manual
says to do a full database backup and restore
Was just thinking the same -
It's only the conversion from V5 to V6 that takes forever. Once you are
V6/DB2, DB backup-restore is fast again.
I have TSM 6.3.4 on Windows, DB is 930G used, DS3512 disk, and it will back up
to LTO5 in 90 minutes if the server isn't doing a lot else at the time
Now that TSM V5 is gone from our shop and we're all TSM V6.2, it's time
to move some things around. Such as the TSM DB2 database. The manual
says to do a full database backup and restore. That could take days of
downtime with our 150-300GB databases, and a lot of angst, so that is
not really
Of Steven
Harris
Sent: Tuesday, March 11, 2014 6:47 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Moving Oracle and DB2 nodes between servers.
Hi All
I'm planning a slow, node-by-node migration from V5 to V6 for one of my
customers. The database is too big to do anything else.
For most types of node
/time to select
just the files that I need.
I also have a similar issue with DB2, although I've discovered that I can
delete a DB2 backup using the BA command line, at least under AIX. There is
however no utility similar to tdposync for DB2, so even if I had the data
from the V5 server I don't know
-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Steven
Harris
Sent: Tuesday, March 11, 2014 6:47 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Moving Oracle and DB2 nodes between servers.
Hi All
I'm planning a slow, node-by-node migration from V5 to V6 for one of my
,
Eric van Loon
AF/KLM Storage Engineering
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Steven Harris
Sent: dinsdag 11 maart 2014 11:47
To: ADSM-L@VM.MARIST.EDU
Subject: Moving Oracle and DB2 nodes between servers.
Hi All
I'm planning a slow
Currently we are backing up daily, DB2 using TSM 6 DB2 API client LAN-Free to
our TM 6 server/Virtual tape library.
Once a week I need to do a DB2 backup with a different retention. I am looking
for options to this solution.
Here are some I have come up with, I am looking for other options
1 - 100 of 776 matches
Mail list logo