Manuals
/
StorageTek
/
Household Appliance
/
Water System
StorageTek
312564001
manual
Lifecycle Director DB2 Manager User Guide, Version
Models:
312564001
1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
189
Download
189 pages
56.09 Kb
1
2
3
4
5
6
7
8
9
Specification
Install
Error codes
OTD10012 Error locating Odct
Access to migrated rows
Tapecntl Command
Envcntl Writetimeout
Database backup and recovery
Clean-up processing
Allocation recovery
Page 3
Image 3
Lifecycle
Director™
DB2 Manager
User Guide
Version 1.1
EC 132056
Revision C
Page 2
Page 4
Page 3
Image 3
Page 2
Page 4
Contents
Lifecycle Directortm
Page
Version
Lifecycle Director DB2 Manager User Guide
Export Destination Control Statement
Table of contents
DB2 Manager Control Region
Introduction Enabling a DB2 Table for Migration Processing
Messages and Codes
Appendices
Introduction
Product Description Introduction
Row migration
Product Functions
Retrieval of migrated rows
Access to migrated rows
Update of migrated rows
Deletion of migrated rows
Management of migrated rows
DB2 Manager storage configuration
Product implementation
Database backup and recovery
DB2 management processing
Database reorganization
Pre-requisites for DB2 Manager implementation
Page
Installation and Implementation
DB2 Manager implementation procedures
Archive Manager implementation
Dataset Name Description
Install distribution libraries
Tapecntl
Update DB2 Manager parameter library
Assign DB2 Manager user identification
Create DB2 Manager control region procedure
Update the system Program Properties Table PPT
Perform MVS host system modifications
Update Flpa or Mlpa definitions
Perform tape management system changes
Allocate DB2 Manager SMF record identifier
Perform STK Host Software Component HSC changes
Update automated reply software controls
Perform DB2 system modifications
Create LCDDB2 system database and grant access authorities
Create DB2 Manager application plan
Resource type Resource name Access required
Enter the value ‘4’
Define Archive Manager databases
Base database definition panel OTSN4300
Storage level definition panel OTSN4301
Volume serial number Unit of allocation
Access Method Services control panel OTSN4302
Verify DB2 Manager installation
DB2 Manager User Guide StorageTek Proprietary
General parameter format
DB2 Manager Parameter Specification
Envcntl Smfrecid
Envcntl parameters
Envcntl Objsize
Tapecntl parameters
Envcntl Writetimeout
Tapecntl Maxdrdr
Tapecntl Maxtwtr
Tapecntl Maxqlen
Tapecntl Tapewait
Tapecntl Command
Page
Control region initialization
DB2 Manager Control Region
Start LCDDB2
DB2
Control region components
Page
SQL Select processing
Processing requests for access to migrated rows
SQL Update processing
SQL error codes
DB2 Manager operator interface
SQL Delete processing
Display summary status
Stg level
Dbid
Example
Display detail status
LCDDB2,D T=T1
Force purge task
LCDDB2,P T=T1
Purge task
Alter DB2 Manager configuration
Page
Maxsched
LCDDB2,SET READTIMEOUT=10
Terminate DB2 Manager control region
IEE600I Reply to 13 Isshutdown
SMF processing
Page
Offset Length Format Description
SMF header section
Database section
Record descriptor section
Request section
Offset Length Format Description
Offset Length Format
Use of the Maxtrdr parameter
Operational considerations
Use of the Maxqlen parameter
Use of the Maxdrdr parameter
Allocation recovery
Shutdown processing
Resource unavailable condition
Enabling a DB2 table for migration processing
Table migration processing Introduction
Enabling activities
Restrictions
Otdbind ASC Cluster
Disabling activities
Page
OTDBP100 the table migration utility
Functions
JCL requirements
Sysin parameter specification
RESTART=YESNO
NEWTAPE=YESNO
Sqlin entry specification
Print reports
Parmlib requirements
Operator commands
Condition codes
Utility failure and restart considerations
DB2 table backup and recovery
Data management processing
DB2 database reorganization
Archive Manager database backup
Archive Manager database backup and recovery
Archive Manager database recovery
Page
Page
DB2 Manager Utilities
OTDBP120 the row restore utility
Exec PGM=OTDBP120,REGION=4096K
Sysin parameter specification
INDEXONLY=YN
Where Acno = ‘123456789’
Objects will be satisfied via DB2 only
OTDBP130 the pre-fetch utility
Clean-up processing
Exec PGM=OTDBP130,REGION=4096K
Sysin parameter specification
PRINT=DETAILSUMMARY
Print reports
Problem. Refer to for a description of the messages
Archive Manager housekeeping processing
OTDBP140 the table analysis utility
DSN=Table.identification.file,DISP=SHR
Select key1, key2, .. .., keyn from tablename
108 DB2 Manager User Guide StorageTek Proprietary
Detailed table analysis report
OTDBP170 the database housekeeping utility
110 DB2 Manager User Guide StorageTek Proprietary
Sysin parameter specification
Ignored. a maximum of 15 records may be present in this file
Detailed processing report
Archive Manager database maintenance
Page
Page
Page
Messages and Codes
OTD100xx table migration utility messages
OTD10000 Row Migration Utility ended with completion code
OTD10001 Open failed for xxxxxxxx dataset
OTD10003 Mandatory exec parameters have not been specified
OTD10005 Load failed for program Dsnali DSNHLI2
120 DB2 Manager User Guide StorageTek Proprietary
OTD10011 Return code Xxx’ retrieving Name/Token pair
OTD10012 Error locating Odct
OTD10015 The control region is not active
OTD10016 Normal run requested but restart run required
OTD10017 Unable to obtain Odre request element
Page
OTD10021 Insufficient storage for workareas
OTD120xx row restore utility messages
OTD12000 Row Restore Utility ended with completion code
OTD12001 Open failed for xxxxxxxx dataset
OTD12004 Mandatory exec parameters have not been specified
OTD12006 Insufficient storage for workareas
OTD12007 Load failed for program Dsnali DSNHLI2
DB2 Manager User Guide 127 StorageTek Proprietary
Sortout
OTD130xx pre-fetch utility messages
OTD13000 Batch Pre-fetch Utility ended with completion code
OTD13001 Open failed for xxxxxxxx dataset
OTD13004 Mandatory exec parameters have not been specified
OTD13006 Insufficient storage for workareas
OTD13007 Load failed for program Dsnali DSNHLI2
DB2 Manager User Guide 131 StorageTek Proprietary
OTD140xx table analysis utility messages
OTD13015 Archive Manager is not at the correct level
OTD14000 Table Analysis Utility ended with completion code
OTD14004 Mandatory exec parameters have not been specified
OTD14001 Open failed for Sysinsqlin dataset
OTD14007 Load failed for program Dsnali DSNHLI2
OTD14006 Insufficient storage for workareas
Page
Page
OTD17001 Open failed for Sysinsqlin dataset
OTD170xx database housekeeping utility messages
OTD17004 Mandatory exec parameters have not been specified
OTD17006 Insufficient storage for workareas
OTD17007 Load failed for program Dsnali DSNHLI2
Page
OTD20001 Error opening parameter file Sysparm
OTD200xx control region master processor messages
OTD20000 Enter request
OTD20006 Envcntl Tapecntl parameter validation errors
OTD20004
OTD20005 Envcntl Tapecntl parameters being processed
OTD20008 Odct Getmain failure
OTD20010 Error Xxx during initialization of task tnnn
OTD20011 Timeout error during initialization of task tnnn
OTD20007 Envcntl Tapecntl parameters successfully processed
OTD20013 Getmain failure Xxx allocating task tnnn
OTD20014 Error Xxx received attaching task tnnn
OTD20017 Intercept successfully established
OTD20016 OTDBP300 is not in Link Pack Area
OTD20026 Control region already initialized job terminating
OTD20019 Error locating DB2 Manager Ascb Jobname
OTD20020 Lifecycle Director V1.1 initialization starting
OTD20021 Initialization completed successfully
OTD20029 Recursive abends intercepted job terminating
OTD20030 Error received posting requestor ECB
OTD20032 Command rejected enter request via Modify command
OTD20028 Unable to continue after abend job terminating
OTD20034 Error X’xx’ received loading program
OTD20049 Task tnnn shutdown request has failed error
OTD20050 Missing or invalid request ignored
OTD20051 Invalid Set operands request ignored
OTD20052 Configuration altered successfully
OTD20058 Display processing completed
OTD20056 Errors altering configuration check system status
OTD20055 Missing/invalid operand request rejected
OTD20057 Requested task tnnn does not exist request ignored
OTD20061 Invalid Display operands request ignored
OTD20060 Task tnnn has been shutdown successfully
OTD20067 Request nnn Stg Level=x Tape=yyyyy Blockid=zzzzzzzz
OTD20073 Task tnnn purge request is being processed
OTD20082 Controller received error posting requestor ECB
OTD20071 Invalid Purge operands request ignored
OTD20072 Task tnnn is already being purged request ignored
OTD20092 Do you want to proceed with shutdown y/n?
OTD20094 Error freeing communications table storage
OTD20083 Task tnnn has not been purged request ignored
OTD20091 Invalid Shutdown operands
OTD220xx control region scheduler messages
OTD20095 Communications table storage area freed
OTD20096 Shutdown processing complete
OTD22004 Invalid request on Scheduler Queue
OTD22003 Storage Release Error Return Code=Xxx T=Snnn
OTD22009 Scheduler task nnn terminated
OTD22008 Scheduler task nnn abend Sxxx intercepted
OTD25001 Invalid Odrh received on entry
OTD250xx control region tape reader messages
OTD25007 Tape rdr task nnn abend Sxxx intercepted
OTD25003 Unable to get exclusive access to Odre resource
OTD25004 Insufficient storage for workareas
OTD25005 Tape rdr task nnn initialization failed
OTD25013 Error xx received writing SMF record
OTD25404 Insufficient storage for workareas
OTD25403 Unable to get exclusive access to Odre resource
OTD254xx control region disk reader messages
OTD25401 Invalid Odrh received on entry
OTD25405 Disk rdr task nnn initialization failed
OTD25407 Disk rdr task nnn abend Sxxx intercepted
OTD25409 Disk rdr task nnn terminated
OTD25413 Error xx received writing SMF record
OTD260xx control region writer messages
OTD26001 Invalid Odwh received on entry
OTD26003 Unable to get exclusive access to Odre resource
OTD26004 Insufficient storage for workareas
OTD26005 Tape wtr task nnn initialization failed
OTD26009 Tape wtr task nnn terminated
OTD26007 Tape wtr task nnn abend Sxxx intercepted
OTD270xx control region housekeeping task messages
OTD27008 Hnnn request timed out Odre
DB2 Manager error and reason codes
OTD27005 Housekeeping task Hnnn terminated
OTD27007 Housekeeping task nnn abend Sxxx intercepted
Reason code Explanation hex
Action
Control region return codes
Explanation
DB2 Manager User Guide 171 StorageTek Proprietary
Appendix a Sample JCL members
Appendices
Otdbdef
174 DB2 Manager User Guide StorageTek Proprietary
DB2 Manager User Guide 175 StorageTek Proprietary
Otdbpkg
Otdbplan
178 DB2 Manager User Guide StorageTek Proprietary
Index
Maxdisk
Page
TSO/ISPF
∎ Contact Us
Reader’s Comment Form
Business Reply Card
StorageTek Proprietary
About Storagetek World Headquarters
Top
Page
Image
Contents