Neil
Some in the past have reported success in moving a database between
platforms by using a database backup on an NFS mounted volume. I
daresay that a SMBFS transfer would accomplish the same thing. There
may also be a big/little endian conversion issue between Sparc and
Intel hardware. If t
Hi all
We have a Linux (Suse 9), server running a MySQL 4.1.10 database and are
currently looking at ways of backing it up. Does anyone out there have any
experience with the TDP for MySQL client and if so does it have to run on a
Windows platform?
My knowledge of Windows and MySQL are sketchy a
Only way of migrating between platforms(Windows > UNIX, UNIX > Windows,
Mainframe > UNIX/Windows and so on) and retain the information stored in
your library is to do a export-import scenario(server-to-server would
probably be the way to go) of all data between the servers.
Best Regards
Danie
On Jun 2, 2005, at 4:37 AM, Farren Minns wrote:
We have a Linux (Suse 9), server running a MySQL 4.1.10 database
and are
currently looking at ways of backing it up. Does anyone out there
have any
experience with the TDP for MySQL client and if so does it have to
run on a
Windows platform?
My kn
Hi chaps/chappesses,
I've had a look in the archives, and there doesn't seem to be an immediate
solution to this one, so please help!
I'm trying to redirect the output of a script containing select statements
to a file in the file system. I can see that the redirect works from the
command line but
Thanks to those of you who answered. I had reckoned that import/export was the
only real option and I've got confirmation of that. What I've also gathered is
that I should change my consultants as they didn't mention it at all!
Thanks again,
Neil
-Original Message-
From: ADSM: Dist S
Hi,
To redirect the output of a select statement to a file, you can write a
macro for the select statement and place the redirect symbol and filename
to redirect to at the end of the macro. Then just call the macro and it
should work fine.
ie:
macro.mac:
Contents of macro.mac should look lik
Hi Jerico,
Thanks for that - works a treat.
Now, some of the results I expect to be zero, but instead TSM reports
'ANR2034E SELECT: No Match found'.
Do you know how I can turn those results into a nice clean zero 0 for my
charts.
Many Thanks,
Mattheww
Jerico Pena <[EMAIL PROTECTED]>
Sent by
Hmm.
We have made a little progress on this; it appears to be related to the
fact the storage agent and the client use 127.0.0.1 to communicate on
the same host, regardless of any COMMMEthod SharedMem options if the
host O/S is not AIX. The latest wisdom from the real unix Guru's here
say the num
Hi
Yes, we have the same issues running LAN-free on Solaris. The peformance
numbers are ugly... According to our Solaris experts it has something todo
with the size of IP packets. However, we tried switching to sharedmem with
no success. We have reported this issue to IBM.
Best Regards
Daniel
Hi Matthew,
I can't say that I would know how to do that with select statements. I'm
not sure if you can use if statements to print 0 if there are no matches
found. But, you could script something that would replace the "no matches"
with 0.
Hope this helps, maybe someone else has a better soluti
Hi Matthew
I notice you have a space after the '>'. I remember a discussion on how
the
'> redirect' gets confused with '> greater than' and the (rather vague)
solution
was to interpret the space after the '>' as an indicator that this was a
greater than, and not a redirect... hence the illegal
On Jun 2, 2005, at 8:36 AM, Matthew Large wrote:
Thanks for that - works a treat.
Now, some of the results I expect to be zero, but instead TSM reports
'ANR2034E SELECT: No Match found'.
Do you know how I can turn those results into a nice clean zero 0
for my
charts.
Matthew -
The only real
Redirection requires spaces around the '>'.
Reference: Admin Ref manual, "Redirecting Command Output".
On Jun 2, 2005, at 9:28 AM, David le Blanc wrote:
Hi Matthew
I notice you have a space after the '>'. I remember a discussion
on how
the
'> redirect' gets confused with '> greater than' an
I don't think that redirection is supported during the execution of a
script, which is why Matthew's original error occurred.
Yes, the issues regarding redirection from within the Admin CLI are that
it is not easy to distinguish when '>' is for redirection versus "greater
than". When redirecting f
That's a funny aspect... No money in it, due to the fact that's freeware? And
here I thought the money was in selling the licenses for the agents... or do
you know something we don't know?
If there is enough MySQL running out there, there should be a market for a TDP
agent to back it up - in fa
We've historically run with a maximum percentage used in the low 70s --
72 to 74 per cent. I've now had two occasions where I hit 100% used and
had sessions refused and operations aborted; the second after increasing
the log space by 15%.
What's the easiest method of determining what was trying to
Neil,
One possible approach is to install the Windows TSM Server, connect it
to the library, then set up server-to-server communications between the
Solaris server and Windows server. Once this is established, you can
use EXPORT NODE to copy the data from the Solaris server to the Windows
server.
*SMers,
Running tiger 10.4.1 from an external disk -- thought I'd try TSM. Running
TSM v 5.2.3
This is on a 15" AlBook with 2 GB RAM.
I copied the preference files and TSM launched and logged in, finding all
my drives. BUT, no matter how many or how few partitions I select to back
up the client
On Jun 2, 2005, at 8:41 AM, Warren, Matthew (Retail) wrote:
We have made a little progress on this; it appears to be related to
the
fact the storage agent and the client use 127.0.0.1 to communicate on
the same host, regardless of any COMMMEthod SharedMem options if the
host O/S is not AIX. ...
try adding MEMORYEFFICIENTBACKUP YES to your dsm.opt file.
John Bremer
<[EMAIL PROTECTED]
> To
Sent by: "ADSM: ADSM-L@vm.marist.edu
Dist Stor
I have no first-hand knowledge of why we do not have a MySQL agent. But I
can make a general comment:
Just because it is "open source" does not mean that it is guaranteed that
IBM will support it. There has to be a sufficient market for the item to
justify (a) the expenditure of the necessary r
We had several issues with LTO2 firmware and library firmware causing false
alarms. I'm make sure your running the latest code
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Wednesday, June 01, 2005 12:54 PM
To: ADSM-L@VM.
I would suggest you go to pSeries. That is the best platform for TSM.
I have many TSM on pSeries, one TSM 5.2 on Linux. The Linux one causes
many problems and AIX/pSeries are pretty stable. By the way, on Linux
TSM Server, I backup 2 TB every night.
On 6/1/05, Patrick Boutilier <[EMAIL PROTECTED]>
24 matches
Mail list logo
