Export command on OS 390

JDionne · #1 (**permalink**) 01-31-08, 12:17

I am running the following command on an OS 390 DB2 8.1.0 system.

Code:

db2 -q "export to /export/home/mldwh/bi_addhoc/load_files/RKSATACT.txt OF DEL 
		select * 
		FROM RKSA.RKSATACT 
		WHERE CREATE_TIME between '2007-11-01-00.00.00.000000' and '2007-11-30-00.00.00.000000' WITH UR"

I am getting the following error:

Code:

SQL1325N  The remote database environment does not support the command or one
of the command options.

I have reviewed the sytax online and I cannot see what I am doing wrong. Can anyone point out what I am doing wrong?

Marcus_A · #2 (**permalink**) 01-31-08, 14:50

The only time I exported a DB2 z/OS table from a DB2 LUW client I used IXF format and it worked ok. I don't know if that is your problem. I would also try it without the UR.

The other issue is to make sure you do a remote bind from the DB2 LUW client of the utilities to the DB2 z/OS server (you will need bind add authority on DB2 z/OS).