DAL: DB2 Data Updates Concerns

We have developed the first phase of an enterprise-wide DSS system using DAL up to a DB/2 database. We need to query information and do real-time updates to the database.

From the query standpoint, everything works fine, but I have some concerns regarding updating the host database. Overall, we want to set up standards and procedures for updating DB/2 data from Macintoshes. Dynamic SQL gives us the capability to update the host, but MIS may not allow its use, due to backup, recovery, security, and other control issues. As alternatives to dynamic SQL, we could use batch mode on the host or COBOL to do the updates.

This is more of an organizational issue than a strict technical problem. Has anyone else faced the same issues, developed guidelines, and so on?
The fact that DAL uses dynamic, not static, SQL is not really the issue. You need to establish security by user or user group regardless of the kind of SQL used to access the tables.

The problems and concerns with backup and recovery are a function of the DB2 design and would exist if you used static SQL and CICS to do transaction updates. If you want neat backup points (for possible recovery later), you will have to do your updates in batch programs with quiesce points before and after. We are not aware of any guidelines established to address this issue.
Published Date: Feb 18, 2012