IBM 51 Manuale Utente

6.

   

Change

 

your

 

password

 

again

 

based

 

on

 

the

 

specified

 

password

 

syntax.

 

 

 

This

 

section

 

includes

 

troubleshooting

 

scenarios

 

for

 

the

 

following

 

problems:

 

v

   

v

   

v

   

v

   

v

   

v

   

v

   

 

 

 

 

 

 

 

 

 

When

 

you

 

run

 

a

 

workflow

 

to

 

deploy

 

resources,

 

you

 

might

 

see

 

a

 

DB2

 

Universal

 

Database

 

error

 

telling

 

you

 

that

 

an

 

SQL

 

exception

 

has

 

occurred.

 

 

This

 

error

 

can

 

occur

 

when

 

the

 

application

 

heap

 

size

 

is

 

not

 

large

 

enough

 

to

 

process

 

the

 

request.

 

 

Increase

 

the

 

application

 

heap

 

size,

 

rebind

 

the

 

packages,

 

terminate

 

all

 

connections,

 

and

 

restart

 

the

 

Tivoli

 

Intelligent

 

Orchestrator

 

server.

 

To

 

complete

 

this

 

task:

 

1.

   

Log

 

on

 

to

 

the

 

DB2

 

Universal

 

Database

 

server

 

as

 

the

 

DB2

 

Universal

 

Database

 

instance

 

owner.

 

2.

   

Open

 

a

 

DB2

 

Universal

 

Database

 

command

 

window

 

and

 

enter

 

the

 

following

 

command

 

to

 

increase

 

the

 

application

 

heap

 

size:

 

db2

 

update

 

db

 

cfg

 

for

 

 

using

 

applheapsz

 

3072

 

where

 

 

is

 

the

 

name

 

of

 

the

 

database

 

you

 

want

 

to

 

modify.

 

3.

   

Under

 

the

 

sqllib\bnd

 

directory,

 

run

 

the

 

following

 

command

 

to

 

rebind

 

the

 

packages:

 

db2

 

connect

 

to

 

 

db2

 

"bind

 

@db2ubind.lst

 

blocking

 

all

 

grant

 

public"

 

db2

 

"bind

 

@db2cli.lst

 

blocking

 

all

 

grant

 

public

 

CLIPKG

 

6"

 

4.

   

Run

 

the

 

following

 

command

 

to

 

terminate

 

all

 

connections:

 

db2

 

force

 

applications

 

all

 

5.

   

Restart

 

the

 

Tivoli

 

Intelligent

 

Orchestrator

 

server.

 

 

 

 

 

 

 

 

Tivoli

 

Intelligent

 

Orchestrator

 

displays

 

a

 

DB2

 

Universal

 

Database

 

error.

 

For

 

example:

 

com.ibm.tivoli.orchestrator.de.dao.PersistentStateException:

 

COPDEX038E

 

A

 

persistent/database

 

state

 

error:

 

[IBM][CLI

 

Driver][DB2/NT]

 

SQL0302N

 

EXECUTE

 

<DB

 

text>

 

SQLSTATE=22001

 

occurred.

 

 

 

Tivoli

 

Intelligent

 

Orchestrator

 

Problem

 

Determination

 

and

 

Troubleshooting

 

Guide