Error 1009172

"%2 is in use by another sp_iqemptyfile or ALTER DBSPACE command. %1"

Item Description

SQLCode

-1009172L

Constant

EMSG_DBSPACE_FILE_IN_USE_BY_ALTER_OR_EMPTY

SQLState

QSB68

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

20226

Severity Code

14

Parameter 1

location of the exception

Parameter 2

Name of the FILE or DBSPACE locked.

Probable cause

sp_iqemptyfile or ALTER DBSPACE commands disallow status change for the FILE(s) or DBSPACE. No other ALTER DBSPACE or sp_iqemptyfile command can run on those FILE(s) or DBSPACE.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com