This IBM Redbook includes several of the announced features for SQL procedures, triggers, and functions in IBM i versions 6.1, 7.1, and 7.2.
This IBM Redpaper publication provides a broad overview and understanding of Db2 Mirror for i by covering its architecture, positioning, planning, and implementation aspects.
This IBM i Redbook covers external stored procedures and triggers, external UDFs, Java procedures, and more.
Scott Forstie, Db2 for i Business Architect, has a gists page where he publishes useful SQL examples.
In this blog post, Db2 expert Kent Milligan reviews key items for a successful Db2 SMP implementation.