Manuale Utente Fujitsu Server 5.0L10 [98/225 Pagine]

Fujitsu server 5.0L10

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

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

· Privilege information (only if -p is specified)

Note:

If a DSI exists for which database space has been allocated, the following information is also printed:

- Information on the allocated DSI (DSI name and type)

- Information on the table related to the DSI (schema name and table name)

- Information on the DSO related to the DSI (DSO name)

- Allocation size

SEQUENCE specification

· Sequence name

· Name of the database to which a sequence belongs

· Name of the schema to which a sequence belongs

· Sequence creator

· Sequence definition date and time

· Sequence number increment interval

· Initial sequence number

· Maximum sequence number

· Minimum sequence number

· Whether to use sequence numbers cyclically

· Number of memory spaces allocated to sequence numbers and number of memory spaces retained with

sequence numbers

· Whether to ensure a sequence between clusters

USER specification

· User name

· User type

· User management type

· Password status

· User creator

· User definition date and time

· Last date and time when the user information was altered (using the ALTER USER statement)

· Last date and time when the user was connected to a database

· Number of times the user failed to connect to a database

· Name and value of each parameter set for the user

ROLE specification

· Role name

· User who defined the role

· Role definition date and time

· Role update date and time

· Resource type

· Database name

· Schema name

· Table name (output if the resource type is TABLE)

· Procedure routine name (output if the resource type is PROCEDURE)

· Function routine name (output if the resource type is FUNCTION)

· Sequence name (output if the resource type is SEQUENCE)

· Trigger name (output if the resource type is TRIGGER)

· Schema name (output if the resource type is SCHEMA)

· Database space name (output if the resource type is DBSPACE)

· Privilege type

· Grantor name

· Grantee names

· Whether the user has the privilege to grant a role

2.14.2 rdbprt command specification method

Figure: Sample database list print specification and Figure: Sample definition information print specification show

sample specifications of the rdbprt command. For more information on specifying the rdbprt command, refer to the

man command (under UNIX) or the SymfoWARE/RDB online manual (under Windows NT).

Sample database list print specification

This example prints a list of all databases in a target SymfoWARE/RDB system.

Fujitsu server B120

Fujitsu server BX400 S1

Fujitsu server 2000

Fujitsu server 2000 SERIES

Fujitsu server T2000

Fujitsu server M5000

Fujitsu server M8000

Fujitsu server TX200FT S2

Fujitsu server V4.90

Fujitsu server RXI300

Fujitsu server T5120

Fujitsu server RX330

Fujitsu server M3000

Fujitsu server M8000

Fujitsu server M8000/M9000

manualioceano.it

Info