Geoff,
This is APAR IC26111. We have a fix that you can download at:
ftp.software.ibm.com
It is in directory:
/storage/tivoli-storage-management/patches/agents/ntsql/1.1.2/
The files are:
IC26111_01.EXE - Self installing executable
IC26111_01.README.FTP - README file
The APAR description is:
IC26111
If a SQL Server 7.0 database is at compatibility level 60 or 65, an
attempt to backup the database or its transaction log would result
in the DB-Lib message "Incorrect syntax near the keyword
'database'" and the backup would fail. This no longer occurs.
Databases at any compatibility level can now be backed up
successfully.
Thanks,
Del
----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com
"Gill, Geoffrey L." <GEOFFREY.L.GILL AT SAIC DOT COM>@VM.MARIST.EDU> on
11/14/2000
10:04:23 AM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: SQL error
I have 6 SQL servers running the client 2 of them are getting the following
error:
11/14/2000 01:08:19,Backed up - DIRECTORY, type: DB, size: 532129653,
actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: CP_ITS_SQLQA, TSM server:
dsm, SQL status: DB-LIB message: Incorrect syntax near the keyword
'database'.
If I back up that database manually I get the same error but this time it
tells me an arror number. I've looked it up and here's the info on it:
ANS1303E Client ended transaction
Explanation: The client system ended the operation with the server and
ended
the current transaction.
System Action: Processing stopped.
User Response: Restart the session.
This error only happens with this specific database on both computers, all
other databases back up fine. Does anyone have any idea what could be the
cause?
SQL Version is 1.1.2
Thanks for the help,
Geoff Gill
NT Systems Support Engineer
SAIC
Computer Systems Group
E-Mail: gillg AT saic DOT com
Phone: (858) 826-4062
Pager: (888) 997-9614
|