Allocating to SYSPROC - IBM
SYSPROC is a system file that originally contained only CLISTs written for applications or for an individual's use. SYSPROC now can also contain execs as long as the execs are distinguishable from CLISTs. The SYSEXEC file is searched first, followed by SYSPROC.
Allocating data sets to SYSPROC - the SPROC CLIST - IBM
SPROC performs the following steps: finds all data sets currently allocated to SYSPROC and concatenates them; then adds the invoker's data set to the beginning of the concatenation and allocates the concatenation to SYSPROC.
Using SYSPROC and SYSEXEC for REXX execs - IBM
You can use SYSPROC for both TSO/E CLISTs and REXX execs. SYSEXEC is for REXX execs only. If an exec is in a data set that is allocated to SYSPROC, the exec must start with a comment containing the characters REXX within the first line (line 1).
Db2 12 - Db2 SQL - Procedures that are supplied with Db2 - IBM
The SYSPROC.ADMIN_COMMAND_DB2 stored procedure executes one or more Db2 commands on a connected Db2 subsystem, or on a Db2 data sharing group member. This stored procedure also returns the command output messages.
Using the SYSPROC and SYSEXEC files - IBM
Using SYSEXEC makes it easier to maintain your REXX execs and is also useful for execs that you use on other SAA environments. If your installation primarily uses CLISTs and does not plan to have a large number of REXX execs, you can use …
Things to Consider When Allocating to a System File (SYSPROC or …
Compression - In certain situations a REXX exec will be compressed to optimize usage of system storage. These situations can arise only when the exec is stored in either SYSPROC or the application-level CLIST file using the ALTLIB command.
GET_SYSTEM_INFO procedure - Get system information - IBM
The schema is SYSPROC. Procedure parameters major_version An input and output argument of type INTEGER that indicates the major document version.
Sysproc probe manager - IBM
The sysproc probe manager provides an infrastructure to users and administrators to dynamically trace process or thread related data without knowing internals of sysproc subsystem.
SYSINSTALLOBJECTS procedure - IBM
call sysproc.sysinstallobjects('geo', 'c', cast (null as varchar(128)), cast (null as varchar(128))) Verify objects that are used for autonomous computing (health monitor). CALL SYSPROC.SYSINSTALLOBJECTS('DB2AC', 'V', CAST (NULL AS VARCHAR(128)), CAST (NULL AS VARCHAR(128)))
ADMIN_REVALIDATE_DB_OBJECTS procedure - Revalidate invalid …
call sysproc.admin_revalidate_db_objects('view', 'my_schema', 'my_view') Example 5: Revalidate all procedures under MY_SCHEMA. In this example, there are three procedures (proc1, proc2, and proc3) under this schema.