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
IBM Corporation
[EMAIL PROTECTED]
"Gill, Geoffrey L." <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 11/14/2000
10:04:23 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
Phone: (858) 826-4062
Pager: (888) 997-9614
