Présentations SQL

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur SQL avec DB2 pour z/OS, disponibles sur le site du GSE Nordic Region :

Recursive and Fun SQL
The ALTERed ALTER - an Evolution
par Peter Backlund

DB2 for z/OS V8 Impacts on SQL and Applications
par Susan Lawson

The ABC’s of SQL Performance Part 1
The ABC’s of SQL Performance Part 2
The ABC’s of SQL Performance Part 3
par Maria Sarikos


Amicalement,

DB2usa.

Sécurité avec DB2 pour z/OS Versions 8 et 9

Bonjour,

Vous trouverez ci-dessous plusieurs documents sur la sécurité avec DB2 pour z/OS Versions 8 et 9, disponibles sur le site web d'IBM :

- Securing DB2 and Implementing MLS on z/OS (Redbook 2007 Versions 8 et 9)
http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246480.html?Open

- Protect, Retain and Comply with Your DB2 Data (Versions 8 and 9 in PDF and MP3)
par Roger Miller
http://www.ibm.com/support/docview.wss?uid=swg27007844

- New DB2 Improvements in Security (Versions 8 and 9)
par Roger Miller
http://www.ibm.com/support/docview.wss?uid=swg27007843


Version 8 uniquement

- For Certain Eyes Only (Article de DB2mag)
par Sasirekha Cota
http://www.db2mag.com/story/showArticle.jhtml?articleID=17602318

- DB2 for z/OS V8 Security Topics, Including Multi-level Security (Version 8)
par Roger Miller
http://www.ibm.com/support/docview.wss?uid=swg27005803

- Best Practices in DB2 Security (Version 8)
par Roger Miller
http://www.ibm.com/support/docview.wss?uid=swg27007842


En savoir plus sur la sécurité

- DB2 for z/OS & OS/390 Security: Protect Your Assets (Versions 6, 7 et 8)
par Roger Miller
http://www.ibm.com/support/docview.wss?&uid=swg27001877


IBM Technotes (FAQ) sur la sécurité

- Should I use the traditional DB2 security or RACF access control?

- Authority removed from external security definition (RACF), however user is still able to run the SQL statement. Dynamic statement caching is enabled

- Can encryption be turned on in the SYSIBM.USERNAMES table for the password column?

- SPUFI or DSNTEP2 message: NOT AUTHORIZED TO USE DB2 SUBSYSTEM xxxx

- Invalid Authorization ID with onlinecheck parameter when customizing an SQLJ program

- Running the RACF access control exit routine for DB2 Version 8 with the RACF database set up for DB2 Version 7

- Why do I get a RACF message even though the CREATE TABLE was successful?

- What is IBM's plan for internal and external security in DB2?

- Is that true that DB2 for z/OS, Version 8 is the last version that will support the internal security

- Does a DB2 user need the triggered action privilege in order to execute a trigger?

- Secondary authorization IDs from CICS to DB2

- Multilevel security: indexes on the security label column


Amicalement,

DB2usa.

Asked and Answered : encore (Robert Catterall)

Bonjour,

Vous trouverez ci-dessous une troisième série de "Questions/Réponses" de Robert Catterall sur DB2 pour z/OS parues dans DB2mag :


- Do you use STOGROUPS in conjunction with SMS?
http://www.db2mag.com/qanda/040120.shtml

- Can you define DB2 catalog and directory data sets to be under SMS control?
http://www.db2mag.com/qanda/031117.shtml

- How do I determine whether or not stored procedures marked as STAY RESIDENT are actually reloading?
http://www.db2mag.com/qanda/031103.shtml

- Can the Distributed Data Facility handle a project that uses dynamic SQL and produces 3,000,000 logs daily with 1,000 concurrent users?
http://www.db2mag.com/qanda/030923.shtml

- What are the maximum limits for segmented and partitioned tablespaces and, how can I convert a nonpartitioned tablespace to a partitioned one without a down time window?
http://www.db2mag.com/qanda/030819a.shtml

- With DB2 Query Parallelism, I've heard that you shouldn't set MAX DEGREE greater than the number of CPs. I don't agree, but I wonder whether setting MAX DEGREE high will have an adverse effect on other users. Any advice?
http://www.db2mag.com/qanda/030819c.shtml

- How do you generate random numbers in DB2?
http://www.db2mag.com/qanda/030722a.shtml

- I have a good understanding of DB2 as an application programmer, but I'm not up on the latest with UDB. Can you suggest a good book that will bring me up to date?
http://www.db2mag.com/qanda/030620a.shtml

- Do you know of any way to detect unused indexes in DB2 (for z/OS and OS/390)? Are there tools or techniques to facilitate identification of such indexes?
http://www.db2mag.com/qanda/030620b.shtml

- Why do 4GB DB2 objects max out at 5,826 cylinders of 3390 storage?
http://www.db2mag.com/qanda/030515.shtml

- Does DASD striping work with DB2 for z/OS and OS/390?
http://www.db2mag.com/qanda/030219.shtml



Amicalement,

DB2usa.