You would expect the SQL world to be standardized, but you will find wide
disparities in implementations and dialects. ENUM is a case in point. In
PostgreSQL, the ENUM type is actually a data type separate from the built in
NUMERIC and TEXT data types, so the regular numeric and string operat
Eric,
If you examine the COLUMNS table for the BACKUPS table, you will see that
the TYPE column is of type "ENUMERATED(OBJECT_TYPE)":
tsm: TSMSERVER1>select colname,typename from columns where
tabname='BACKUPS'
COLNAMETYPENAME
-- --
NODE_NAME
: Re: SQL error
Eric,
Maybe the wildcard % is not valid for the datatype of TYPE which is
ENUMERATED(OBJECT_TYPE).
Have you tried * ?
Rick
On Tue, Mar 12, 2013 at 10:49 AM, Loon, EJ van - SPLXM <
eric-van.l...@klm.com> wrote:
> Hi TSM-ers!
>
> I'm trying to retrieve all
Eric,
Maybe the wildcard % is not valid for the datatype of TYPE which is
ENUMERATED(OBJECT_TYPE).
Have you tried * ?
Rick
On Tue, Mar 12, 2013 at 10:49 AM, Loon, EJ van - SPLXM <
eric-van.l...@klm.com> wrote:
> Hi TSM-ers!
>
> I'm trying to retrieve all image backups for a specific node. I'm
>
Constantly. Opened a PMR yesterday afternoon.
Fred Johanson
TSM Administrator
University of Chicago
773-702-8464
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Vinicius Fraga
Sent: Thursday, September 06, 2007 12:29 PM
To: ADSM-L@VM.MARIST.EDU
S
egards Robert
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
> Of
Del
> Hoobler
> Sent: Wednesday, February 11, 2004 5:40 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Sql Error
>
> Robert,
>
> Looks like Data Protec
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Del
> Hoobler
> Sent: Wednesday, February 11, 2004 5:40 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Sql Error
>
> Robert,
>
> Looks like Data Protection for SQL
obert
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del
Hoobler
Sent: Wednesday, February 11, 2004 5:40 PM
To: [EMAIL PROTECTED]
Subject: Re: Sql Error
Robert,
Looks like Data Protection for SQL is not talking to the local SQL server
correctly.
Robert,
Looks like Data Protection for SQL is not
talking to the local SQL server correctly.
What happens when you issue this command:
TDPSQLC QUERY SQL *
Can you connect to the SQL server that way?
Are you running on a cluster?
Is it a named instance?
Have you tried specifying the SQL Serve
Christo,
I don't ever recall seeing this.
What did the SQL Server log show?
How about the NT event log?
Is this a user-defined database or a system database that you are
restoring?
If you cannot get it figured out, you should call
IBM/Tivoli support. We will probably have to get Microsoft involv
$)C
Hello,
A few things to check...
Make sure the SQL userid "sa" has the Sysadmin fixed server role.
It appears that you are using "sa" because your command line entry
does not show you using /SQLSECURE option (for Windows authentication)
or the /SQLUSER and /SQLPWD options for entering altern
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
12 matches
Mail list logo
