!db2expln -database SAMPLE -statement "SELECT e.lastname, e.job, d.deptname, d.location, p.projname FROM employee AS e, department AS d, project AS p  WHERE e.workdept = d.deptno AND e.workdept = p.deptno" -graph -terminal

!db2expln -database SAMPLE -statement "SELECT A.SALES_REASON, SUM(CAST(A.TOTAL_DUE AS DECIMAL(31, 0))) AS C2 FROM BISTUDIO_EXAMPLE999 A INNER JOIN BISTUDIO_EXAMPLE998 B ON A.ORDERDATE = B.ORDERDATE WHERE A.ORDERDATE > '8/8/2005' GROUP BY A.SALES_REASON UNION ALL SELECT A.SALES_REASON, A.TOTAL_DUE FROM BISTUDIO_EXAMPLE999 A WHERE A.TOTAL_DUE > (SELECT AVG(TOTAL_DUE) FROM BISTUDIO_EXAMPLE999 WHERE SALES_REASON = A.SALES_REASON)"-graph -terminal

!db2expln -database SAMPLE -statement "SELECT "BISTUDIO_EXAMPLE999"."SALES_REASON" FROM "DB2ADMIN"."BISTUDIO_EXAMPLE998" "BISTUDIO_EXAMPLE998" FULL OUTER JOIN "DB2ADMIN"."BISTUDIO_EXAMPLE999" "BISTUDIO_EXAMPLE999" ON "BISTUDIO_EXAMPLE998"."CARD_TYPE" = "BISTUDIO_EXAMPLE999"."CARD_TYPE" -graph -terminal

!db2expln -database SAMPLE -statement "SELECT "BISTUDIO_EXAMPLE998"."CITY", SUM(CAST("SALES"."SALES" AS DECIMAL(31, 0))) AS "c2" FROM "DB2ADMIN"."BISTUDIO_EXAMPLE998" "BISTUDIO_EXAMPLE998" INNER JOIN "DB2ADMIN"."SALES" "SALES" ON "BISTUDIO_EXAMPLE998"."CUSTOMER_NAME" = "SALES"."SALES_PERSON" GROUP BY "BISTUDIO_EXAMPLE998"."CITY"" -graph -terminal

!db2expln -database SAMPLE -statement "select tabname,tabschema,property,compression,tableorg from syscat.tables where tabname like '%STAFF%'" -graph -terminal

!db2expln -database SAMPLE -statement "select tabname,tabschema,property,compression,tableorg from syscat.tables where tabname like '%BISTUDIO_EXAMPLE998%'" -graph -terminal

!db2expln -database SAMPLE -statement "SELECT "BISTUDIO_EXAMPLE998"."SALES_REASON","BISTUDIO_EXAMPLE999"."CURRENCY_CODE","BISTUDIO_EXAMPLE998"."CURRENCY_CODE" FROM "BLU"."BISTUDIO_EXAMPLE999" "BISTUDIO_EXAMPLE999" CROSS JOIN "BLU"."BISTUDIO_EXAMPLE998" "BISTUDIO_EXAMPLE998" WHERE   ("BISTUDIO_EXAMPLE998"."CARD_TYPE" = 'VISTA')" -graph -terminal

!db2expln -database SAMPLE -statement "SELECT SORT_SHRHEAP_ALLOCATED, SORT_SHRHEAP_TOP FROM TABLE(MON_GET_DATABASE(-1)) AS T" -graph -terminal

!db2expln -database SAMPLE -statement "SELECT * FROM DB2ADMIN.DEPARTMENT d where d.DEPTNAME = ? order by d.DEPTNO" -graph -terminal

!db2expln -database SAMPLE -statement "SELECT A.SALES_REASON, A.TOTAL_DUE FROM BISTUDIO_EXAMPLE999 A WHERE A.TOTAL_DUE > (SELECT AVG(TOTAL_DUE) FROM BISTUDIO_EXAMPLE999 WHERE SALES_REASON = A.SALES_REASON)" -graph -terminal

!db2expln -database SAMPLE -statement "SELECT A.SALES_REASON, SUM(CAST(A.TOTAL_DUE AS DECIMAL(31, 0))) AS C2 FROM BISTUDIO_EXAMPLE999 A INNER JOIN BISTUDIO_EXAMPLE998 B ON A.ORDERDATE = B.ORDERDATE WHERE A.ORDERDATE > '8/8/2005' GROUP BY A.SALES_REASON"-graph -terminal

!db2expln -database SAMPLE -statement "SELECT  * FROM "ADMINISTRATOR"."STAFF" "STAFF" INNER JOIN "BLU"."DEPARTMENT" "DEPARTMENT" ON "STAFF"."NAME" = "DEPARTMENT"."DEPTNAME"" -graph -terminal