Loading data of DB2 z/OS internal format into a DB2 Linux/Unix/Windows database became very easy.
Either you use DB2 Connect to connect from any DB2 Linux/Unix/Windows to DB2 for z/OS. But ... weiterlesen
Does your application has to check cerrtain authorzation id's for certain access rights needed? Following SQL shows some ways how to proceed:
In this sample the SQL's have to check incoming ... weiterlesen
xmpTBSCStmt.pl provides following functions:
creates CREATE TABLESPACE statements for existing database
creates REDIRECTED RESTORE statements for a database you possibly want to or need to recover at a remote site
creates ... weiterlesen
xmpTerm.pl provides following functions ...
lists all databases (local and remote) at current DB2 instance
lists all connections at the DB2 instance, or only those connected to a specified database
terminates all connections,Â or ... weiterlesen
Do you want to generate a timestamp in external DB2 format YYYY-MM-DD-HH.MM.SS.ssssss?
Use either following functions which is already part of the xmpPerl.pm function library:
Or try following Perl statements which ... weiterlesen
Perl script to administer files, especially DB2 administration files, like db2diag.log, admin log file, or any other file. It helps to archive, compress, rename or delete one or more files,Â optionally ... weiterlesen
Activate requested DB2 environment:
Search for registered DB2 software version, instances, databases and execute the appropriate DB2 environment. The KSH shell script is quite useful on sites with more than one ... weiterlesen
Perl script to create UPDATE DB|DBM CFG statements for databases and instances, prints ordered list of confuguration options. Enables users to "copy" or "save" configurations.