R: [ADSM-L] R: [ADSM-L] Can't start the server - SOLVED

2018-05-24 Thread Tommaso Bollini
Hi Eric and Shawn, I've solved with the re-installation of the packages:

gskcrypt64-8.0-14.51
gskssl64-8.0-14.51

that I got  in the 6.4.3.2-TIV-TSMBAC-LinuxX86.tar from the ftp://storsys site.
Product version 8.0.14.51 of the above, in a 7.1.7 SP SLES11 environment works 
fine :)

Not solved with: http://www-01.ibm.com/support/docview.wss?uid=swg21642264

I even had solved, in a virtual clone of my 7.1.7 (server with testing 
purposes), with reinstall of the SP product only (Uninstall + Install) and with 
a 8.0-50.66 GSK release (8.1.0 BA).

Many many many thanks to you.
Regards.

-Messaggio originale-
Da: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Per conto di Shawn 
Drew
Inviato: giovedì 24 maggio 2018 04:50
A: ADSM-L@VM.MARIST.EDU
Oggetto: Re: [ADSM-L] R: [ADSM-L] Can't start the server

I had this problem when testing a restore to a different server with a slight 
different version of the gskit installed as a part of the client.
Check if this is the version you have installed:

http://www-01.ibm.com/support/docview.wss?uid=swg22007298

I was able to fix it by downgrading the gskit that comes with the TSM client 
and baclient.
Not sure if the appropriate fix levels are available. The article says AIX but 
affected me on RHEL6/7



On 5/23/2018 11:09 AM, Tommaso Bollini wrote:
> Hi Eric, yes I can do db2start or log on with the instance user on DB2. My 
> get dbm cfg output is below.
> I've found that the stash file, it is written by the server: if I remove that 
> file, the Spectrum recreates it.
>   There is my problem: the file will have zero bytes in size; so no stash -> 
> no login and after the final error SQL30082N for username/password invalid.
> 
> Do you know how Spectrum read that password?
> 
> I have tried this: 
> http://www-01.ibm.com/support/docview.wss?uid=swg21642264
> But unsuccesfully. It seems that the SRVCON_PW_PLUGIN parameter its mandatory.
> 
> db2 => get dbm cfg
> 
> Database Manager Configuration
> 
>   Node type = Enterprise Server Edition with local and remote 
> clients
> 
>   Database manager configuration release level= 0x1000
> 
>   CPU speed (millisec/instruction) (CPUSPEED) = 3.267047e-07
>   Communications bandwidth (MB/sec)  (COMM_BANDWIDTH) = 1.00e+02
> 
>   Max number of concurrently active databases (NUMDB) = 32
>   Federated Database System Support   (FEDERATED) = NO
>   Transaction processor monitor name(TP_MON_NAME) =
> 
>   Default charge-back account   (DFT_ACCOUNT_STR) =
> 
>   Java Development Kit installation path   (JDK_PATH) = 
> /home/tsmadmin/sqllib/java/jdk64
> 
>   Diagnostic error capture level  (DIAGLEVEL) = 3
>   Notify Level  (NOTIFYLEVEL) = 3
>   Diagnostic data directory path   (DIAGPATH) = 
> /home/tsmadmin/sqllib/db2dump/
>   Current member resolved DIAGPATH= 
> /home/tsmadmin/sqllib/db2dump/
>   Alternate diagnostic data directory path (ALT_DIAGPATH) =
>   Current member resolved ALT_DIAGPATH=
>   Size of rotating db2diag & notify logs (MB)  (DIAGSIZE) = 1024
> 
>   Default database monitor switches
> Buffer pool (DFT_MON_BUFPOOL) = ON
> Lock   (DFT_MON_LOCK) = OFF
> Sort   (DFT_MON_SORT) = OFF
> Statement  (DFT_MON_STMT) = OFF
> Table (DFT_MON_TABLE) = OFF
> Timestamp (DFT_MON_TIMESTAMP) = ON
> Unit of work(DFT_MON_UOW) = OFF
>   Monitor health of instance and databases   (HEALTH_MON) = OFF
> 
>   SYSADM group name(SYSADM_GROUP) = TSMSRVRS
>   SYSCTRL group name  (SYSCTRL_GROUP) =
>   SYSMAINT group name(SYSMAINT_GROUP) =
>   SYSMON group name(SYSMON_GROUP) =
> 
>   Client Userid-Password Plugin  (CLNT_PW_PLUGIN) =
>   Client Kerberos Plugin(CLNT_KRB_PLUGIN) =
>   Group Plugin (GROUP_PLUGIN) =
>   GSS Plugin for Local Authorization(LOCAL_GSSPLUGIN) =
>   Server Plugin Mode(SRV_PLUGIN_MODE) = UNFENCED
>   Server List of GSS Plugins  (SRVCON_GSSPLUGIN_LIST) =
>   Server Userid-Password Plugin(SRVCON_PW_PLUGIN) = dsmdb2pw
>   Server Connection Authentication  (SRVCON_AUTH) = NOT_SPECIFIED
>   Cluster manager =
> 
>   Database manager authentication(AUTHENTICATION) = SERVER
>   Alternate authentication   (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
>   Cataloging allowed without authority   (CATALOG_NOAUTH) = NO
>   Trust all clients  (TRUST_ALLCLNTS) = YES
>   Trusted client authentication  (TRUST_CLNTAUTH) = CLIENT
>   Bypass federated authentication(FED_NOAUTH) = NO
> 
>

Re: Can't start the server

2018-05-24 Thread Loon, Eric van (ITOPT3) - KLM
Hi Tommaso,
So DB2 is working OK. Check the mail from Shawn first, slightly different GSKit 
levels will indeed result in very vague errors. If that is not working I think 
it's time to open a call at IBM...
Kind regards,
Eric van Loon
Air France/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Tommaso Bollini
Sent: woensdag 23 mei 2018 17:10
To: ADSM-L@VM.MARIST.EDU
Subject: R: [ADSM-L] Can't start the server

Hi Eric, yes I can do db2start or log on with the instance user on DB2. My get 
dbm cfg output is below.
I've found that the stash file, it is written by the server: if I remove that 
file, the Spectrum recreates it.
 There is my problem: the file will have zero bytes in size; so no stash -> no 
login and after the final error SQL30082N for username/password invalid.

Do you know how Spectrum read that password?

I have tried this: http://www-01.ibm.com/support/docview.wss?uid=swg21642264
But unsuccesfully. It seems that the SRVCON_PW_PLUGIN parameter its mandatory.

db2 => get dbm cfg

Database Manager Configuration

 Node type = Enterprise Server Edition with local and remote clients

 Database manager configuration release level= 0x1000

 CPU speed (millisec/instruction) (CPUSPEED) = 3.267047e-07
 Communications bandwidth (MB/sec)  (COMM_BANDWIDTH) = 1.00e+02

 Max number of concurrently active databases (NUMDB) = 32
 Federated Database System Support   (FEDERATED) = NO
 Transaction processor monitor name(TP_MON_NAME) = 

 Default charge-back account   (DFT_ACCOUNT_STR) = 

 Java Development Kit installation path   (JDK_PATH) = 
/home/tsmadmin/sqllib/java/jdk64

 Diagnostic error capture level  (DIAGLEVEL) = 3
 Notify Level  (NOTIFYLEVEL) = 3
 Diagnostic data directory path   (DIAGPATH) = 
/home/tsmadmin/sqllib/db2dump/
 Current member resolved DIAGPATH= 
/home/tsmadmin/sqllib/db2dump/
 Alternate diagnostic data directory path (ALT_DIAGPATH) = 
 Current member resolved ALT_DIAGPATH= 
 Size of rotating db2diag & notify logs (MB)  (DIAGSIZE) = 1024

 Default database monitor switches
   Buffer pool (DFT_MON_BUFPOOL) = ON
   Lock   (DFT_MON_LOCK) = OFF
   Sort   (DFT_MON_SORT) = OFF
   Statement  (DFT_MON_STMT) = OFF
   Table (DFT_MON_TABLE) = OFF
   Timestamp (DFT_MON_TIMESTAMP) = ON
   Unit of work(DFT_MON_UOW) = OFF
 Monitor health of instance and databases   (HEALTH_MON) = OFF

 SYSADM group name(SYSADM_GROUP) = TSMSRVRS
 SYSCTRL group name  (SYSCTRL_GROUP) = 
 SYSMAINT group name(SYSMAINT_GROUP) = 
 SYSMON group name(SYSMON_GROUP) = 

 Client Userid-Password Plugin  (CLNT_PW_PLUGIN) = 
 Client Kerberos Plugin(CLNT_KRB_PLUGIN) = 
 Group Plugin (GROUP_PLUGIN) = 
 GSS Plugin for Local Authorization(LOCAL_GSSPLUGIN) = 
 Server Plugin Mode(SRV_PLUGIN_MODE) = UNFENCED
 Server List of GSS Plugins  (SRVCON_GSSPLUGIN_LIST) = 
 Server Userid-Password Plugin(SRVCON_PW_PLUGIN) = dsmdb2pw
 Server Connection Authentication  (SRVCON_AUTH) = NOT_SPECIFIED
 Cluster manager = 

 Database manager authentication(AUTHENTICATION) = SERVER
 Alternate authentication   (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
 Cataloging allowed without authority   (CATALOG_NOAUTH) = NO
 Trust all clients  (TRUST_ALLCLNTS) = YES
 Trusted client authentication  (TRUST_CLNTAUTH) = CLIENT
 Bypass federated authentication(FED_NOAUTH) = NO

 Default database path   (DFTDBPATH) = /home/tsmadmin

 Database monitor heap size (4KB)  (MON_HEAP_SZ) = AUTOMATIC(90)
 Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
 Audit buffer size (4KB)  (AUDIT_BUF_SZ) = 0
 Global instance memory (4KB)  (INSTANCE_MEMORY) = AUTOMATIC(22523032)
 Member instance memory (4KB)= GLOBAL
 Agent stack size   (AGENT_STACK_SZ) = 1024
 Sort heap threshold (4KB)  (SHEAPTHRES) = 0

 Directory cache support (DIR_CACHE) = YES

 Application support layer heap size (4KB)   (ASLHEAPSZ) = 15
 Max requester I/O block size (bytes) (RQRIOBLK) = 65535
 Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

 Priority of agents   (AGENTPRI) = SYSTEM
 Agent pool size(NUM_POOLAGENTS) = AUTOMATIC(100)
 Initial number of agents in pool   (NUM_INITAGENTS) = 0
 Max number of co