(Troy L Coleman) DB2 11 introduced autonomous procedures, which give a called stored procedure the capability to COMMIT its work without committing the work in the calling program. Why would you need this? Let’s consider one scenario where this feature would be useful.
Tag: IBM
SQL 101: A Simple Way to Add Data to the DB: the Insert Statement
(Rafael Victoria-Pereira) RPG and DFU provide ways to add new records to your files. RPG forces you to write a program, regardless of how simple or small the data you want to add is, and DFU is a not the friendliest tool to manipulate data. It can be useful to quickly change a couple of records, but
Lightweight Java servers and developer view on the App Server (update)
(Roman Kharkovski) It’s been two years since I wrote the original article comparing Liberty Profile, WAS classic, Tomcat, Jetty, WildFly, JBoss, GlassFish and WebLogic from a developer point of view.
Using Autonomous Procedures
(Troy L Coleman) DB2 11 introduced autonomous procedures, which give a called stored procedure the capability to COMMIT its work without committing the work in the calling program. Why would you need this? Let’s consider one scenario where this feature would be useful.
Integrating PureApplication System into an Existing Datacenter
(Alan E Booth, Erhan Ekici, Venkata Gadepalli, Rajeev Gandhi, Addison Goering, Ivan Pryanichnikov, Vincent T Tran and Hendrik Van Run) This IBM Redbooks publication will help with the integration of PureApplication System and PureApplication Software into an existing datacenter. This publication dis
SQL0286N A table space could not be found with a page size of at least 32768
(Jack Vamvas) Question: I got this error on MYDB on MYSERVER: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
Tablespace backups in a DB2 LUW DPF database
(Pavan Kristipati) In this blog post, I will share about few gotchas to look out for when backing up tablespaces in a DB2 DPF database. What is DPF? I wrote a detailed blog post on db2commerce.com.
Integrating PureApplication System into an Existing Datacenter
(Alan E Booth, Erhan Ekici, Venkata Gadepalli, Rajeev Gandhi, Addison Goering, Ivan Pryanichnikov, Vincent T Tran and Hendrik Van Run) This IBM Redbooks publication will help with the integration of PureApplication System and PureApplication Software into an existing datacenter. This publication dis
SQL0286N A table space could not be found with a page size of at least 32768
(Jack Vamvas) Question: I got this error on MYDB on MYSERVER: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
Tablespace backups in a DB2 LUW DPF database
(Pavan Kristipati) In this blog post, I will share about few gotchas to look out for when backing up tablespaces in a DB2 DPF database. What is DPF? I wrote a detailed blog post on db2commerce.com.
