CREATE WRAPPER DRDA LIBRARY 'db2drda.dll' OPTIONS (FENCED 'Y');

CREATE SERVER DB2SMPL TYPE DB2/UDB VERSION  8 . 2  WRAPPER DRDA
AUTHORIZATION "db2remote" PASSWORD "db2pass"
OPTIONS (DBNAME 'SAMPLE');

CREATE USER MAPPING FOR ALONZO SERVER DB2SERVER
OPTIONS (REMOTE_AUTHID 'db2remote', REMOTE_PASSWORD 'db2pass');

CREATE NICKNAME <localschema>.t1
     FOR DB2SMPL.<remotechema>.t1

select * from <localschema>.t1