The following sequence of statements would be used in an OS/390 SAS session to establish a connection to DB2 and query the table SYSIBM.SYSTABLES: connect to db2 (ssid=db2p); select * from connection ...

Because the wrappers also know how each database processes queries, such as the number of tables that can be accessed per query, DB2’s query-processing engine “can decide the best way to ...

The queries are written to the SAS log. For example, if you submit a PROC PRINT statement that references a DB2 table, the DB2 SQL query is displayed in the SAS log. The SAS/ACCESS engine for DB2 ...

I'm not familiar with db2; however a database I used in the past would choke on using OR with a field in the index being used. It too would resort to a table scan.

On the Web, IBM provided an example of how 32-core system using BLU technologies could execute a query against a 10TB data set in less than a second. “In that 10TB, you’re [probably ...

Whenever any query comes up that has that common element, DB2 already has the execution plan worked out so it doesn’t have to recalculate it. This feature greatly increases the efficiency of ...

In DB2, the execution time is shown in a separate pop-up window and it goes away as soon as the query is finished, so if you’re not watching it, you have no idea how long it took.

"People with detailed queries currently extract the data (from DB2 databases) to use with BI," Livesey said. "They don't do it in the database itself because the (performance of the) database ...