Publicaciones

  • DB2 Top 10 SQL por Tiempo de Ejecución

    By Oscar_paredes on 15 Septiembre, 2019 - 09:50

    Si quieres obtener el Top Ten de sentencias SELECT con mayor tiempo de ejecución en tu base de datos DB2:

    db2 "SELECT AVERAGE_EXECUTION_TIME_S as TIME_SECONDS, 

        NUM_EXECUTIONS as EXECUTIONS,

        STMT_TEXT as TEXT

        FROM SYSIBMADM.TOP_DYNAMIC_SQL

        WHERE upper(STMT_TEXT) like 'SELECT%'

       ORDER BY AVERAGE_EXECUTION_TIME_S DESC

        FETCH FIRST 10 ROWS ONLY"

  • Options db2 command line – Disable autocommit

    By Oscar_paredes on 13 Septiembre, 2019 - 10:27

    DB2 command line utility has different options. In this post we show how to disable the autocommit of DML statements that by default is active. In case you want to do some test, for example, simulating the use of locks could be helpful to disable this feature.

    Options from DB2 command line can be obtained with the following sentences:

  • DB2 Top 10 SQL for execution time

    By Oscar_paredes on 13 Septiembre, 2019 - 10:18

    SQL Command to obtain the Top Ten of SELECT SQL sentences with more execution time in your DB2 database:

    db2 "SELECT AVERAGE_EXECUTION_TIME_S as TIME_SECONDS, 

        NUM_EXECUTIONS as EXECUTIONS,

        STMT_TEXT as TEXT

        FROM SYSIBMADM.TOP_DYNAMIC_SQL

        WHERE upper(STMT_TEXT) like 'SELECT%'

        ORDER BY AVERAGE_EXECUTION_TIME_S DESC

        FETCH FIRST 10 ROWS ONLY"

     

  • DB2 with BLU Acceleration for SAP

    By Oscar_paredes on 13 Septiembre, 2019 - 09:20

    Every time it’s more common SAP environments running with DB2.

    Attached a video regarding the capabilities of DB2 with BLU Acceleration applied to SAP and all SAP notes to consider.

    Surprising comparative with SAP HANA, and as with less complexity and investment, you get more performance.

    Pay attention to the comparison with SAP HANA:

    Attached also the IBM Redbook Architecting and Deploying DB2 with BLU Acceleration.

     

  • DB2 con BLU Acceleration para SAP

    By Oscar_paredes on 13 Septiembre, 2019 - 08:39

    Cada vez conozco más entornos SAP corriendo con DB2.

    Este es un video muy interesante respecto a las capacidades de DB2 con BLU Acceleration aplicadas a SAP, así como las notas SAP a considerar.

    Sorprendente la comparativa con SAP HANA, y como con menor complejidad e inversión dicen obtener mayor rendimiento.

     

    Adjunto también presentación de la Tech Talk Use DB2 with BLU Acceleration for SAP, de la que destaco las sorprendentes conclusiones de esta comparación de BD2 BLU Acceleration con SAP HANA:

  • DB2 Write Suspend

    By Oscar_paredes on 30 Enero, 2019 - 17:47

    When doing a snapshot from a storage array, if the server contains a DB2 instance running, there is no certainty that the snapshot contains a consistent copy of the database.

    To launch a snapshot and ensure consistent copy in DB2 is possible to put the database at “write suspend”, that is, it overrides the disk access in write mode, and work in the buffer pool memory. Queries whether it will record but writes are performed only in memory.