Stored procedures in SYSPROC schema

[efiryago]

Are stored procedures in SYSPROC schema documented and supportedd? I am
particularly intersted in the procedure SYSPROC.DB2LOAD which seems to
be a SQL wrapper to the db2 load API. If that is true, my SQL stored
procedures could benefit from having LOAD API accessibility without
need to write a C stored proc to call it.
Forgot to mention... I found it in DB2 V8.1.8 AIX and Linux after I
upgraded from V8.1.4.

Regards,
-Eugene

[Mark A]

<ef******@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Are stored procedures in SYSPROC schema documented and supportedd? I am
particularly intersted in the procedure SYSPROC.DB2LOAD which seems to
be a SQL wrapper to the db2 load API. If that is true, my SQL stored
procedures could benefit from having LOAD API accessibility without
need to write a C stored proc to call it.
Forgot to mention... I found it in DB2 V8.1.8 AIX and Linux after I
upgraded from V8.1.4.

Regards,
-Eugene

Check out the Administrative API Reference and see if that is what you are
looking for.

[efiryago]

You are referring to the DB2 admin C API ref, whereas I am seeking the
description for stored procs in SYSPROC schema that seem to be a
wrappers around some admin API calls.

-Eugene

[Serge Rielau]

ef******@gmail.com wrote:

You are referring to the DB2 admin C API ref, whereas I am seeking the
description for stored procs in SYSPROC schema that seem to be a
wrappers around some admin API calls.

-Eugene

I don't think there is any harm in using it. Just be aware that the
signature may be changed in a future release.
When you taek a look at V8.2.2 (FP9)
you will find a generic admin procedure which shows teh direction where
DB2 is going for these:
http://publib.boulder.ibm.com/infoce...n/r0012547.htm

Supported now are:
# DESCRIBE
# EXPORT
# PRUNE HISTORY/LOGFILE
# REORG INDEXES/TABLE
# RUNSTATS
# UPDATE DATABASE CONFIGURATION

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab