you have to invoke the full path of compress in your profile or in the
backup scripts:
/usr/bin/compress
then you can invoke in in your scripts:

time db2 -v backup db ${DATABASE} to ${BACKUP_DIR} with 4 buffers compress
without prompting


"hsteiner" <db2udbdba-ezmlmshield-x85623533.[Email address protected] wrote
on 09/27/2005 11:47:24 AM:

> I know that you can compress Backups since one of the V8 FixPaks. I
> have successfully used it in at least two DB2 UDB V8 environments. I
> am currently running on a Sun Solaris server and when I code a
> BACKUP... COMPRESS I receive a SQL2072N Unable to bind the shared
> library error message.

> I believe I need to code a COMPRLIB value, but I don't remember
> which library to use. Can anyone help?

> Thanks, Hal

>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page