The syntax is:
libname <name> db2 database=<database> schema=<schema> user=<user> password=<password> in=<tablespace>;
Eg.
libname testname db2 database=mydb schema=myschema user=domain.com\myuser password=”1234Hello” in=mytablespace;
The connection to the database has to be created eg through the DB2 ControlCenter before it is possible to connect to it in SAS.
‘in=’ determins the tablespace where the data is placed.