Usage Note 37497: A DB2 error occurs when you attempt to set DB2 permissions for SAS Accelerator Publishing Agent for DB2
The following error message is issued when you attempt to set DB2 GRANT CREATEIN permissions:
DB21034E The command was processed as an SQL statement because
it was not a valid Command Line Processor command. During SQL
processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003
You must connect to the database before issuing a DB2 GRANT CREATEIN command using commands similar to the following example:
db2 => connect to database-name user user-id using password
db2 => grant createin on schema schema-name to user-id
Operating System and Release Information
| SAS System | SAS Scoring Accelerator for DB2 | Microsoft Windows Server 2003 Datacenter Edition | 1.6 | | 9.2 TS2M2 | |
| Microsoft® Windows® for x64 | 1.6 | | 9.2 TS2M2 | |
| Microsoft Windows XP 64-bit Edition | 1.6 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 1.6 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 1.6 | | 9.2 TS2M2 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 1.6 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 Enterprise Edition | 1.6 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 Standard Edition | 1.6 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2008 | 1.6 | | 9.2 TS2M2 | |
| Microsoft Windows XP Professional | 1.6 | | 9.2 TS2M2 | |
| Windows Vista | 1.6 | | 9.2 TS2M2 | |
| 64-bit Enabled AIX | 1.6 | | 9.2 TS2M2 | |
| 64-bit Enabled HP-UX | 1.6 | | 9.2 TS2M2 | |
| 64-bit Enabled Solaris | 1.6 | | 9.2 TS2M2 | |
| HP-UX IPF | 1.6 | | 9.2 TS2M2 | |
| Linux | 1.6 | | 9.2 TS2M2 | |
| Linux for x64 | 1.6 | | 9.2 TS2M2 | |
| Solaris for x64 | 1.6 | | 9.2 TS2M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2
|
| Date Modified: | 2009-10-21 15:42:18 |
| Date Created: | 2009-10-19 12:33:31 |
