ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » IBM MQ API Support » MQ worflow db connection issue

Post new topic  Reply to topic
 MQ worflow db connection issue « View previous topic :: View next topic » 
Author Message
zaklum
PostPosted: Mon Apr 18, 2005 11:14 am    Post subject: MQ worflow db connection issue Reply with quote

Voyager

Joined: 17 Mar 2005
Posts: 96
Location: Boca Raton

here is the problem:
After a three tier installation of workflow using an oracle database server I ran the fmczutil and I encounter the following: when connecting to the runtime database from the client db to the server db as fmc user Id, I first establish the connection, but then I loose connection and try reconnecting again. When trying to connect for a second time, the utility is not able to connect.
default username is fmc and password is password.

questions: why is the utility trying to connect for a second time?
with what username and password is the 2nd connection going thru? is it the same as the first? if so, why is not accepting the username and/or password?
please see output below

fmc@servername:/var/fmc/cfgs/FMC/sql #> fmczutil
FMC33201I Configuration Commands Menu:
l ... List
s ... Select
x ... Exit Configuration Commands Menu
s
Configuration identifier : [FMC]
FMC33202I Selected Configuration Commands Menu:
Selected configuration : FMC (Default configuration)
c ... Configuration Settings Menu
r ... Runtime Database Commands Menu
q ... Queue Manager Commands Menu
x ... Exit Selected Configuration Commands Menu
r
FMC33206I Selected Runtime Database Commands Menu:
Selected Runtime database : dbname
s ... Create SQL files
t ... Create tables
u ... Drop tables
f ... Import topology FDL
o ... Optimize Database
p ... Change password
x ... Exit Selected Runtime Database Commands Menu
t

FMC33041I Specify the user ID to access the Runtime database ...:
FMC33436I Tables are created with this username as a prefix.
Oracle user ID to access Runtime database : [fmc]

Enter password for user ID 'fmc' : []
Confirm password for user ID 'fmc' : []

FMC33003I /u011001/app/oracle/product/9.2.0/bin/sqlplus fmc/********@dbname.TYCO.NET @/var/fmc/cfgs/FMC/fmczctab.sql

SQL*Plus: Release 9.2.0.6.0 - Production on Mon Apr 18 14:20:58 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production

SQL>
SQL> spool /var/fmc/cfgs/FMC/log/fmczctab.log
SQL>
SQL> -- ***********************************************************************************
SQL> -- MQSeries Workflow Database Creation Script
SQL> --
SQL> -- generated at: 2005-04-18 17:33:53
SQL> -- on host : servername
SQL> -- **********************************************************************************
SQL>
SQL>
SQL> DEFINE SPOOLFILE_FOR_ORACLE_SCRIPTS=/var/fmc/cfgs/FMC/log/createDict.log
SQL> DEFINE SPOOLFILE_FOR_TBS_CREATION=/var/fmc/cfgs/FMC/log/fmczctbs.log
SQL>
SQL> set termout off
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production
FMC33978E Oracle call 'connect' ended with SQL code 'ORA-01017: invalid username/password; logon denied'.
FMC33206I Selected Runtime Database Commands Menu:
Selected Runtime database : wfltst01
s ... Create SQL files
t ... Create tables
u ... Drop tables
f ... Import topology FDL
o ... Optimize Database
p ... Change password
x ... Exit Selected Runtime Database Commands Menu





Second screen on the DB server.




OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
TIMESTAMP_WF TYPE VALID 18-apr-05 14:02:40
ACTIVITY_WORK_ITEM TABLE VALID 18-apr-05 14:02:41
BLAI_BLOCK_IMPL INDEX VALID 18-apr-05 14:02:41
BLAI_PROCESS INDEX VALID 18-apr-05 14:02:41
BLOCK_INST TABLE VALID 18-apr-05 14:02:41
CONTAINER TABLE VALID 18-apr-05 14:02:41
PCAI_PROCESS INDEX VALID 18-apr-05 14:02:41
PGAI_PROCESS INDEX VALID 18-apr-05 14:02:41
PI_STATE INDEX VALID 18-apr-05 14:02:41
PK_BLOCK_ACT_INST INDEX VALID 18-apr-05 14:02:41
PROCESS_INST TABLE VALID 18-apr-05 14:02:41
PROCESS_ACT_INST TABLE VALID 18-apr-05 14:02:41
PK_PROGRAM_ACT_INST INDEX VALID 18-apr-05 14:02:41
PK_PROC_INST_EXEC_RES INDEX VALID 18-apr-05 14:02:41
PK_PROCESS_INST INDEX VALID 18-apr-05 14:02:41
PK_PROCESS_ACT_INST INDEX VALID 18-apr-05 14:02:41
PK_NOTIFICATION_ITEM INDEX VALID 18-apr-05 14:02:41
PK_CONTAINER INDEX VALID 18-apr-05 14:02:41
PK_BLOCK_INST INDEX VALID 18-apr-05 14:02:41
TIMESTAMP_WF TYPE BODY VALID 18-apr-05 14:02:41
PROGRAM_ACT_INST TABLE VALID 18-apr-05 14:02:41
PROC_INST_EXEC_RES TABLE VALID 18-apr-05 14:02:41
PK_ACTIVITY_WORK_ITEM INDEX VALID 18-apr-05 14:02:41
PI_NAME INDEX VALID 18-apr-05 14:02:41
PCAI_SUBPROC_IID INDEX VALID 18-apr-05 14:02:41
NOTIFICATION_ITEM TABLE VALID 18-apr-05 14:02:41
BLOCK_ACT_INST TABLE VALID 18-apr-05 14:02:41

OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
AT_CREATED_PROCID INDEX VALID 18-apr-05 14:02:42
AUDIT_TRAIL TABLE VALID 18-apr-05 14:02:42
CONTAINER_DATA_SEG TABLE VALID 18-apr-05 14:02:42
WORK_ITEM TABLE VALID 18-apr-05 14:02:42
WI_STATE INDEX VALID 18-apr-05 14:02:42
WI_PIID INDEX VALID 18-apr-05 14:02:42
WI_OWNER_STATE INDEX VALID 18-apr-05 14:02:42
WI_BIIDAIID INDEX VALID 18-apr-05 14:02:42
PK_PROGRAM_REG_TEMPL INDEX VALID 18-apr-05 14:02:42
PK_LOC_W_I_STUBS_SEG INDEX VALID 18-apr-05 14:02:42
PK_GCON_MAPPING INDEX VALID 18-apr-05 14:02:42
PK_CONTAINER_DATA_SEG INDEX VALID 18-apr-05 14:02:42
NI_NOTIFIED INDEX VALID 18-apr-05 14:02:42
NI_BIIDAIID INDEX VALID 18-apr-05 14:02:42
LOC_W_I_STUBS_SEG TABLE VALID 18-apr-05 14:02:42
GCON_MAPPING TABLE VALID 18-apr-05 14:02:42
GCM_ATTR_PT_NAME INDEX VALID 18-apr-05 14:02:42
SYS_LOB0000006617C00004$$ LOB VALID 18-apr-05 14:02:42
SYS_LOB0000006613C00004$$ LOB VALID 18-apr-05 14:02:42
SYS_LOB0000006609C00004$$ LOB VALID 18-apr-05 14:02:42
SYS_LOB0000006602C00011$$ LOB VALID 18-apr-05 14:02:42
REM_W_I_STUBS_SEG TABLE VALID 18-apr-05 14:02:42
PROGRAM_REG_TEMPL TABLE VALID 18-apr-05 14:02:42
PK_WORK_ITEM INDEX VALID 18-apr-05 14:02:42
PK_REM_W_I_STUBS_SEG INDEX VALID 18-apr-05 14:02:42
ACTIVITY_TEMPL TABLE VALID 18-apr-05 14:02:43
ACTTMPL_ATID INDEX VALID 18-apr-05 14:02:43



OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
BLOCK_TEMPL TABLE VALID 18-apr-05 14:02:43
CONTAINER_TEMPL TABLE VALID 18-apr-05 14:02:43
CONTROL_CONNECTOR TABLE VALID 18-apr-05 14:02:43
DATA_CONNECTOR TABLE VALID 18-apr-05 14:02:43
DC_TARGET_CTNR_NUM INDEX VALID 18-apr-05 14:02:43
DATA_STRUCT_TEMPL TABLE VALID 18-apr-05 14:02:43
SYS_LOB0000006689C00008$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006683C00009$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006683C00008$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006679C00008$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006675C00003$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006656C00056$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006656C00055$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006656C00054$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006656C00051$$ LOB VALID 18-apr-05 14:02:43
WORK_ITEM_VIEW TABLE VALID 18-apr-05 14:02:43
SYS_LOB0000006705C00036$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006698C00012$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006694C00008$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006656C00048$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006656C00007$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006656C00005$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006635C00047$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006635C00044$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006635C00035$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006635C00030$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006635C00028$$ LOB VALID 18-apr-05 14:02:43

OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
PERSON TABLE VALID 18-apr-05 14:02:43
O_PARENT INDEX VALID 18-apr-05 14:02:43
O_NAME INDEX VALID 18-apr-05 14:02:43
O_MANAGER INDEX VALID 18-apr-05 14:02:43
ORGANIZATION TABLE VALID 18-apr-05 14:02:43
LEVEL_WF TABLE VALID 18-apr-05 14:02:43
ACT_NOT_TEMPL TABLE VALID 18-apr-05 14:02:43
ACT_TEMPL_RES_ASG TABLE VALID 18-apr-05 14:02:43
SYS_LOB0000006635C00014$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006635C00013$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006631C00003$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006627C00002$$ LOB VALID 18-apr-05 14:02:43
SYS_LOB0000006623C00007$$ LOB VALID 18-apr-05 14:02:43
PK_PROGRAM_IMPL_TEMPL INDEX VALID 18-apr-05 14:02:43
PK_PROC_SET_TEMPL INDEX VALID 18-apr-05 14:02:43
PK_PROCESS_TEMPL INDEX VALID 18-apr-05 14:02:43
PK_PERSON INDEX VALID 18-apr-05 14:02:43
PK_ORGANIZATION INDEX VALID 18-apr-05 14:02:43
PK_LEVEL INDEX VALID 18-apr-05 14:02:43
PK_DATA_STRUCT_TEMPL INDEX VALID 18-apr-05 14:02:43
PK_DATA_CONNECTOR INDEX VALID 18-apr-05 14:02:43
PK_CONTROL_CONNECTOR INDEX VALID 18-apr-05 14:02:43
PK_CONTAINER_TEMPL INDEX VALID 18-apr-05 14:02:43
PK_BLOCK_TEMPL INDEX VALID 18-apr-05 14:02:43
PK_ACT_TEMPL_RES_ASG INDEX VALID 18-apr-05 14:02:43
PT_NAME_VALID INDEX VALID 18-apr-05 14:02:43
PROGRAM_IMPL_TEMPL TABLE VALID 18-apr-05 14:02:43

OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
PROC_SET_TEMPL TABLE VALID 18-apr-05 14:02:43
PROCESS_TEMPL TABLE VALID 18-apr-05 14:02:43
PK_WORK_ITEM_VIEW INDEX VALID 18-apr-05 14:02:43
PK_ACT_NOT_TEMPL INDEX VALID 18-apr-05 14:02:43
PK_ACTIVITY_TEMPL INDEX VALID 18-apr-05 14:02:43
CATEGORY TABLE VALID 18-apr-05 14:02:44
ORG_HIERARCHY TABLE VALID 18-apr-05 14:02:44
DOMAIN TABLE VALID 18-apr-05 14:02:44
C_NAME INDEX VALID 18-apr-05 14:02:44
PER_AUTH_FOR_WITMS TABLE VALID 18-apr-05 14:02:44
PER_HAS_ROLE TABLE VALID 18-apr-05 14:02:44
SYS_LOB0000006756C00129$$ LOB VALID 18-apr-05 14:02:44
SYS_LOB0000006751C00029$$ LOB VALID 18-apr-05 14:02:44
SYS_LOB0000006747C00118$$ LOB VALID 18-apr-05 14:02:44
SYS_LOB0000006742C00007$$ LOB VALID 18-apr-05 14:02:44
SYS_LOB0000006737C00032$$ LOB VALID 18-apr-05 14:02:44
SYS_LOB0000006721C00007$$ LOB VALID 18-apr-05 14:02:44
SYS_LOB0000006715C00010$$ LOB VALID 18-apr-05 14:02:44
SYSTEM_WF TABLE VALID 18-apr-05 14:02:44
SVR_NAME INDEX VALID 18-apr-05 14:02:44
SERVER TABLE VALID 18-apr-05 14:02:44
R_NAME INDEX VALID 18-apr-05 14:02:44
R_COORDINATOR INDEX VALID 18-apr-05 14:02:44
ROLE_WF TABLE VALID 18-apr-05 14:02:44
QUEUE_MANAGER TABLE VALID 18-apr-05 14:02:44
QMG_NAME INDEX VALID 18-apr-05 14:02:44
P_SYSTEM_GROUP INDEX VALID 18-apr-05 14:02:44

OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
P_SYSTEM INDEX VALID 18-apr-05 14:02:44
P_SUBSTITUTE INDEX VALID 18-apr-05 14:02:44
P_ORGANIZATION INDEX VALID 18-apr-05 14:02:44
P_NAME INDEX VALID 18-apr-05 14:02:44
P_LEVEL INDEX VALID 18-apr-05 14:02:44
PK_ROLE INDEX VALID 18-apr-05 14:02:44
PK_QUEUE_MANAGER INDEX VALID 18-apr-05 14:02:44
PK_PROGRAM_EXEC_AGENT INDEX VALID 18-apr-05 14:02:44
PK_PER_HAS_ROLE INDEX VALID 18-apr-05 14:02:44
PK_PER_AUTH_FOR_WITMS INDEX VALID 18-apr-05 14:02:44
PK_PER_AUTH_FOR_CATEG INDEX VALID 18-apr-05 14:02:44
PK_ORG_HIERARCHY INDEX VALID 18-apr-05 14:02:44
PK_DOMAIN INDEX VALID 18-apr-05 14:02:44
PK_CATEGORY INDEX VALID 18-apr-05 14:02:44
PROGRAM_EXEC_AGENT TABLE VALID 18-apr-05 14:02:44
PK_SYSTEM INDEX VALID 18-apr-05 14:02:44
PK_SERVER INDEX VALID 18-apr-05 14:02:44
PHR_ROLE INDEX VALID 18-apr-05 14:02:44
PHR_PERSON INDEX VALID 18-apr-05 14:02:44
PER_AUTH_F_WI_IDX INDEX VALID 18-apr-05 14:02:44
PER_AUTH_FOR_CATEG TABLE VALID 18-apr-05 14:02:44
PEA_NAME INDEX VALID 18-apr-05 14:02:44
DATA_STRUCTURE TABLE VALID 18-apr-05 14:02:45
DS_OID INDEX VALID 18-apr-05 14:02:45
ERROR_LOG TABLE VALID 18-apr-05 14:02:45
S_NAME INDEX VALID 18-apr-05 14:02:45
S_ID INDEX VALID 18-apr-05 14:02:45

OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
SYS_OBS_SYS TABLE VALID 18-apr-05 14:02:45
PROGRAM TABLE VALID 18-apr-05 14:02:45
PROCESS_MODEL_SEG TABLE VALID 18-apr-05 14:02:45
PROCESS_MODEL TABLE VALID 18-apr-05 14:02:45
PM_OID INDEX VALID 18-apr-05 14:02:45
PK_SYS_OBS_SYS INDEX VALID 18-apr-05 14:02:45
PK_SYSTEM_STATE INDEX VALID 18-apr-05 14:02:45
PK_SYSTEM_LOG INDEX VALID 18-apr-05 14:02:45
PK_SYSTEM_GROUP INDEX VALID 18-apr-05 14:02:45
PK_SVR_INSTANCE_STATE INDEX VALID 18-apr-05 14:02:45
SYS_LOB0000006774C00006$$ LOB VALID 18-apr-05 14:02:45
SYS_LOB0000006769C00006$$ LOB VALID 18-apr-05 14:02:45
SYS_LOB0000006762C00123$$ LOB VALID 18-apr-05 14:02:45
SYSTEM_STATE TABLE VALID 18-apr-05 14:02:45
SYSTEM_LOG TABLE VALID 18-apr-05 14:02:45
SYSTEM_GROUP TABLE VALID 18-apr-05 14:02:45
SVR_INSTANCE_STATE TABLE VALID 18-apr-05 14:02:45
SG_NAME INDEX VALID 18-apr-05 14:02:45
PK_PROGRAM INDEX VALID 18-apr-05 14:02:45
PK_PROCESS_MODEL_SEG INDEX VALID 18-apr-05 14:02:45
PK_PROCESS_MODEL INDEX VALID 18-apr-05 14:02:45
PK_ERROR_LOG INDEX VALID 18-apr-05 14:02:45
PK_DATA_STRUCTURE INDEX VALID 18-apr-05 14:02:45
PGM_OID INDEX VALID 18-apr-05 14:02:45
PK_PRIVATE_AI_LIST INDEX VALID 18-apr-05 14:02:46
PK_PUBLIC_PT_LIST INDEX VALID 18-apr-05 14:02:46
SYS_LOB0000006869C00009$$ LOB VALID 18-apr-05 14:02:46

OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
SYS_LOB0000006869C00008$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006869C00005$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006858C00013$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006858C00012$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006858C00011$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006858C00008$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006847C00010$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006847C00009$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006869C00010$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006847C00008$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006847C00005$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006836C00013$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006836C00012$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006836C00011$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006836C00008$$ LOB VALID 18-apr-05 14:02:46
PUBLIC_WORK_LIST TABLE VALID 18-apr-05 14:02:46
PRIVATE_PT_LIST TABLE VALID 18-apr-05 14:02:46
PRIVATE_PTL_NAME INDEX VALID 18-apr-05 14:02:46
PRIVATE_PI_LIST TABLE VALID 18-apr-05 14:02:46
PRIVATE_PIL_NAME INDEX VALID 18-apr-05 14:02:46
PRIVATE_AI_LIST TABLE VALID 18-apr-05 14:02:46
PRIVATE_AIL_NAME INDEX VALID 18-apr-05 14:02:46
PK_PUBLIC_WORK_LIST INDEX VALID 18-apr-05 14:02:46
PK_PUBLIC_PI_LIST INDEX VALID 18-apr-05 14:02:46
PK_PRIVATE_WORK_LIST INDEX VALID 18-apr-05 14:02:46
SYS_LOB0000006803C00011$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006803C00010$$ LOB VALID 18-apr-05 14:02:46

OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
SYS_LOB0000006803C00006$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006792C00015$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006792C00014$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006792C00013$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006792C00009$$ LOB VALID 18-apr-05 14:02:46
SESSION_WF TABLE VALID 18-apr-05 14:02:46
PUBLIC_WL_NAME INDEX VALID 18-apr-05 14:02:46
SYS_LOB0000006825C00010$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006825C00009$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006825C00008$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006825C00005$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006814C00013$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006814C00012$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006814C00011$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006814C00008$$ LOB VALID 18-apr-05 14:02:46
SYS_LOB0000006803C00012$$ LOB VALID 18-apr-05 14:02:46
PUBLIC_PT_LIST TABLE VALID 18-apr-05 14:02:46
PUBLIC_PTL_NAME INDEX VALID 18-apr-05 14:02:46
PUBLIC_PI_LIST TABLE VALID 18-apr-05 14:02:46
PUBLIC_PIL_NAME INDEX VALID 18-apr-05 14:02:46
PUBLIC_AI_LIST TABLE VALID 18-apr-05 14:02:46
PUBLIC_AIL_NAME INDEX VALID 18-apr-05 14:02:46
PRIVATE_WORK_LIST TABLE VALID 18-apr-05 14:02:46
PRIVATE_WL_NAME INDEX VALID 18-apr-05 14:02:46
PK_PRIVATE_PT_LIST INDEX VALID 18-apr-05 14:02:46
PK_PRIVATE_PI_LIST INDEX VALID 18-apr-05 14:02:46
PK_PUBLIC_AI_LIST INDEX VALID 18-apr-05 14:02:46

OBJECT_NAME OBJECT_TYPE STATUS CREATED
------------------------------ ------------------ ------- ------------------
PERSON_WI_AMOUNT TABLE VALID 18-apr-05 14:02:47
SYS_GROUP_OID TABLE VALID 18-apr-05 14:02:47
W_OID INDEX VALID 18-apr-05 14:02:47
W_SYSTEM_GROUP INDEX VALID 18-apr-05 14:02:47
W_WI_AMOUNT INDEX VALID 18-apr-05 14:02:47
W_SYSTEM INDEX VALID 18-apr-05 14:02:47
SYS_GRP_IDX INDEX VALID 18-apr-05 14:02:47
SES_LOGON INDEX VALID 18-apr-05 14:02:47
PK_SESSION INDEX VALID 18-apr-05 14:02:47
PK_SYS_GROUP_OID INDEX VALID 18-apr-05 14:02:47
PK_PERSON_WI_AMOUNT INDEX VALID 18-apr-05 14:02:47

254 rows selected.

SQL>
Back to top
View user's profile Send private message
RogerLacroix
PostPosted: Mon Apr 18, 2005 7:03 pm    Post subject: Reply with quote

Jedi Knight

Joined: 15 May 2001
Posts: 3264
Location: London, ON Canada

Dude, post your questions in the right forum!!!!
_________________
Capitalware: Transforming tomorrow into today.
Connected to MQ!
Twitter
Back to top
View user's profile Send private message Visit poster's website
kotha
PostPosted: Fri May 06, 2005 11:54 am    Post subject: Reply with quote

Partisan

Joined: 12 Mar 2005
Posts: 333

Did you get it fixed. If so, how did u solve it?

are u using WAS for the WF client?. I need to install the 3-tier in future.

If u installed 3-tier setup, What is the process? How can I proceede?

Your answers greatly aprriciated
Back to top
View user's profile Send private message
vennela
PostPosted: Fri May 06, 2005 12:11 pm    Post subject: Reply with quote

Jedi Knight

Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India

It is all in the installation guide.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » IBM MQ API Support » MQ worflow db connection issue
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.