SAPTechArena

DB2 Table and Index Commands Look at columns and data types of a table db2 describe table schema.tabelename Look at one column's data type. db2 "describe select <colname> from schema.tablename" Look at indexes on a table db2 describe indexes for table schema.tablename Export data to a file in ixf format db2 export to tablename.ixf of ixf messages tablename.txt select...

DB2 Security Commands Build a script to grant user execute privilege on all packages. db2 "select 'db2 grant execute on package '||pkgschema||'.'||pkgname||' to user <user>;' from syscat.packages where pkgschema = 'NULLID'" > output.file Security Notes dbadm auth must be revoked before any other database privlege create_not_fenced_routine must be revoked before...

DB2 Backup and Restore Commands Take an OFFLINE backup db2 connect to <dbname> db2 quiesce database immediate force connections db2 connect reset db2 backup database <dbname> to <path> compress without prompting after backup completes: db2 connect to <dbname> db2 unquiesce database db2 connect reset Take an ONLINE Backup db2 backup db <dbname>...

Basic Commands Size of your database :  db2 'call get_dbsize_info(?,?,?,0)' Version of DB2 you are running: db2level Stop the db2 instance: db2stop Stop an instance that has current connections db2 force applications all db2 deactivate db <dbname> db2 terminate db2stop force ipclean Start the db2 instance: db2start Kill a hung instance (last resort): db2_kill -all List the...

SAPTECHARENA FORUM!!! ...

RSTXCNVR Converting a SAPscript Standard Text to RAW or ITF Format and Download the File RSTXCPDF Routines for Converting OTF Format to PDF FormatRSTXDBUG Activate/Deactivate Form DebuggerRSTXFDEL Delete and Repair the FormsRSTXHTML Conversion of SAPscript Texts (ITF) to HTMLRSTXLDMC Uploading TIFF Files to SAPscript TextsRSTXSCRP SAPscript Export to Dataset / SAPscript Import from...

Tips and Tricks This space is for those bits of information that can save you a lot of time and trouble and usually are hard to find in the documentation.  Problems with username/passwords while setting JCO's?... try with the password in UPPERCASE. Going home in a hurry?, use transaction /nex to close all your sessions at the same time in specific application...

This guide is written with an intention to help those who are trying to Install SAP GUI 7.30 in Mac OS X 10.9 Mavericks platform and ended up with installing Windows OS in Mac machines due to limited information availability related to Mac & Java configuration. Requirements: Installer of SAP GUI 7.30 for Java enviroment Java 7 for OS X (Link : http://www.java.com/en/download/help/mac_install.xml) Pre-installed...