Usage Note 46712: Option for debugging META Libname Engine libraries
 |  |  |  |  |
A new Libname statement option, LIBDEBUG, is available for SAS® libraries assigned with the META Libname Engine. The option reports to the SAS log the Libname statement which is generated behind the scenes when the META Libname Engine is used. This option can be useful in troubleshooting library assignment.
The following example demonstrates the use of the LIBDEBUG option and shows the LIBDEBUG data returned to the SAS log.
LIBNAME MYLIB META
library="Oracle Library"
server="sasbi.demo.sas.com"
port="8561"
user="sasbi\sas"
password=XXXXXXXXXX
repname="Foundation"
protocol=BRIDGE
LIBDEBUG;
LIBDEBUG: Libname ORALIB ORACLE PATH=ALIEN USER='scott'
PASSWORD='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' SCHEMA='SCOTT';
NOTE: Libref MYLIB was successfully assigned as follows:
Engine: META
Physical Name: ALIEN
You might see an additional message reading:
NOTE: Libref WORK refers to the same library metadata as libref .
Ignore this message.
The LIBDEBUG option is only valid on a Libname statement using the META Libname Engine. Using the option on a Libname statement that does not use the META Libname engine produces the syntax error:
ERROR 22-7: Invalid option name LIBDEBUG.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Aster Data nCluster on Linux x64 | 9.3 TS1M0 | |
| DB2 Universal Database on AIX | 9.3 TS1M0 | |||
| DB2 Universal Database on Linux x64 | 9.3 TS1M0 | |||
| Greenplum on Linux x64 | 9.3 TS1M0 | |||
| Netezza TwinFin 32bit blade | 9.3 TS1M0 | |||
| Netezza TwinFin 32-bit SMP Hosts | 9.3 TS1M0 | |||
| Netezza TwinFin 64-bit S-Blades | 9.3 TS1M0 | |||
| Netezza TwinFin 64-bit SMP Hosts | 9.3 TS1M0 | |||
| Teradata on Linux | 9.3 TS1M0 | |||
| z/OS | 9.3 TS1M0 | |||
| Z64 | 9.3 TS1M0 | |||
| Microsoft® Windows® for x64 | 9.3 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | |||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | |||
| Microsoft Windows Server 2008 | 9.3 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | |||
| Microsoft Windows XP Professional | 9.3 TS1M0 | |||
| Windows 7 Enterprise 32 bit | 9.3 TS1M0 | |||
| Windows 7 Enterprise x64 | 9.3 TS1M0 | |||
| Windows 7 Home Premium 32 bit | 9.3 TS1M0 | |||
| Windows 7 Home Premium x64 | 9.3 TS1M0 | |||
| Windows 7 Professional 32 bit | 9.3 TS1M0 | |||
| Windows 7 Professional x64 | 9.3 TS1M0 | |||
| Windows 7 Ultimate 32 bit | 9.3 TS1M0 | |||
| Windows 7 Ultimate x64 | 9.3 TS1M0 | |||
| Windows Vista | 9.3 TS1M0 | |||
| Windows Vista for x64 | 9.3 TS1M0 | |||
| 64-bit Enabled AIX | 9.3 TS1M0 | |||
| 64-bit Enabled HP-UX | 9.3 TS1M0 | |||
| 64-bit Enabled Solaris | 9.3 TS1M0 | |||
| HP-UX IPF | 9.3 TS1M0 | |||
| Linux | 9.3 TS1M0 | |||
| Linux for x64 | 9.3 TS1M0 | |||
| Solaris for x64 | 9.3 TS1M0 | |||
A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#46712| Type: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> LIBNAME Engines SAS Reference ==> Statements ==> Data Access ==> LIBNAME for the Metadata Engine |
| Date Modified: | 2012-06-18 15:53:50 |
| Date Created: | 2012-05-31 15:21:14 |