Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB2 on AIX equivalet commands of Oracle on Unix.

Status
Not open for further replies.

tekpr00

IS-IT--Management
Jan 22, 2008
186
0
0
CA
Hello All:

I am new to DB2 UDB on AIX having being Oracle DBA for some time. I am looking for equivalent of the following Oracle/Unix commands for DB2/AIX.

signing into database from unix prompt in differentn ways depending on user priviledge.
-sqlplus scott/tiger@ORCL
-sqlplus system@orcle
-sqlplus / as sysdba

Other DB2 equivalent commands that I am interested in:
-VERIFY ALL INSTANCES ARE UP
-LOOK FOR ANY NEW ALERT LOG ENTRIES
-VERIFY DBSNMP IS RUNNING
-VERIFY SUCCESS OF DATABASE BACKUP
-VERIFY SUCCESS OF DATABASE ARCHIVING TO TAPE
-VERIFY ENOUGH RESOURCES FOR ACCEPTABLE PERFORMANCE
-COPY ARCHIVED LOGS TO STANDBY DATABASE AND ROLL FORWARD

Please note that I have searched the web with no success. I am looking for succinct commands that will allow an Oracle DBA to pivot to DB2 DBA successfully.

Thanks in advance

Tekpr00
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top