TDP4sql T-log does not work as expected

[xixao]

Hello guys,
I did set up a full and diff backup and it parsed the logs without an issue but here I have stopped thinking and might be a simple solution..
I am struggling to get my .bat and Log backup working on the SQL server and getting an error message like that:

C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc backup * Log /SqlServer=xxxx /SQLAUTHentication=INTegrated /Stripes=1 /Truncate=Yes /EXCLUDESTandarddbs /tsmoptfile="C:\Program Files\Tivoli\TSM\TDPSql\dsmlog.opt"

IBM Spectrum Protect for Databases:
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 17.0
(C) Copyright IBM Corporation 1997, 2022. All rights reserved.

ACO5716W An error was encountered with IBM Spectrum Protect API initialization, rc = 400.
Examine the dsierror.log for more information or determine if the IBM Spectrum Protect API is installed properly.

In the dsierror.log:
10/20/2023 16:28:59 ANS0361I DIAG: A record has been deleted from password file, due to password change or wrong password.
10/23/2023 23:00:08 ANS0220E An invalid option was found during option parsing.
10/24/2023 00:00:04 ANS0220E An invalid option was found during option parsing.
10/24/2023 11:00:06 ANS0220E An invalid option was found during option parsing.
10/24/2023 11:16:38 ANS0220E An invalid option was found during option parsing.
10/24/2023 11:28:03 ANS0220E An invalid option was found during option parsing.
10/24/2023 12:00:02 ANS0220E An invalid option was found during option parsing.
10/24/2023 13:00:02 ANS0220E An invalid option was found during option parsing.
10/24/2023 14:00:02 ANS0220E An invalid option was found during option parsing.
10/24/2023 15:00:02 ANS0220E An invalid option was found during option parsing.
10/24/2023 15:29:02 ANS0220E An invalid option was found during option parsing.
10/24/2023 15:29:58 ANS0220E An invalid option was found during option parsing.
10/24/2023 15:52:31 ANS0220E An invalid option was found during option parsing.
10/24/2023 16:00:01 ANS0220E An invalid option was found during option parsing.

dsmlog.opt
NODename xxxx_SQL
PASSWORDAccess generate
TCPServeraddress x.x.x.x
TCPPort PORT 1508
HTTPport 1582
INCLUDE * M_SQLL_01A
CLUSTERnode no
EXCLUDE "\...\No_TDP_*\...\*"
ERRORLOGRETENTION 21 D
SCHEDLOGRETENTION 21 D

 

[Cyrax0]

Hello,
I think the ANS0220E error is due to the dsmlog.opt parameter
TCP port PORT 1508
should be
TCPPort 1508

Regards,

 

[xixao]

Hi,
Yes, it helped but I see another error there appeared?

IBM Spectrum Protect for Databases:
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 17.0
(C) Copyright IBM Corporation 1997, 2022. All rights reserved.

Connecting to SQL Server, please wait...

ACO5552I No matches were found for the criteria specified.

 

[xixao]

Hello,
I figured out by my own where is the problem with another parameter: /EXCLUDESTandarddbs

tdpsqlc backup * Log /SqlServer=xxxx /SQLAUTHentication=INTegrated /Stripes=1 /Truncate=Yes /tsmoptfile="C:\Program Files\Tivoli\TSM\TDPSql\dsmlog.opt"

Thank you for the mismatched with TCPPort 1508.
Have a good one.