• United States
IBM?
  • Site map
IBM?
  • Marketplace

  • Close
    Search
  • Sign in
    • Sign in
    • Register
  • IBM Navigation
IBM Developer Answers
  • Spaces
    • Blockchain
    • IBM Cloud platform
    • Internet of Things
    • Predictive Analytics
    • Watson
    • See all spaces
  • Tags
  • Users
  • Badges
  • FAQ
  • Help
Close

Name

Community

  • Learn
  • Develop
  • Connect

Discover IBM

  • ConnectMarketplace
  • Products
  • Services
  • Industries
  • Careers
  • Partners
  • Support
10.190.13.206

Refine your search by using the following advanced search options.

Criteria Usage
Questions with keyword1 or keyword2 keyword1 keyword2
Questions with a mandatory word, e.g. keyword2 keyword1 +keyword2
Questions excluding a word, e.g. keyword2 keyword1 -keyword2
Questions with keyword(s) and a specific tag keyword1 [tag1]
Questions with keyword(s) and either of two or more specific tags keyword1 [tag1] [tag2]
To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +[tag1].
  • Ask a question

Set logarchmet1 disk on Windows

06000283EN gravatar image
Question by 06000283EN  (0) | Feb 26, 2016 at 09:56 AM db2dbdsupportwindowsbackuphivaluerestore

Hello,

For my IBM Connections databases I want to configure an archive log path per database. The final goal is to write these logs directly to a server share but first I want to get

it work properly on local drive. So here z: is a local drive, it is the drive on which the database instance resides.

What am I doing wrong with this command to I need use a different syntax?

Running DB2 10.5 FP7 64-bits on a Windows 2012 R2 server, UAC disabled.

Thanks in advance.

Cheers, Marco

Z:\Db2backups\DB2IIC\backup_images>db2 "UPDATE DB CFG FOR OPNACT USING logarchmeth1 disk:z:\db2backups\archive_logs\OPNACT"
SQL5099N The value "z:\db2backups\archive_logs\OPNACT" indicated by the
database configuration parameter "LOGARCHMETH1" is not valid, reason code "2".SQLSTATE=08004

db2diag.log is giving me this:

2016-02-26-11.49.05.737000+060 I55605561F515 LEVEL: Error
PID : 4336 TID : 3912 PROC : db2syscs.exe
INSTANCE: DB2IIC NODE : 000 DB :
APPHDL : 0-3032 APPID: *LOCAL.DB2IIC.160209140231
AUTHID : DB2IIC HOSTNAME: DB2
EDUID : 3912 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlfVerifyLogArchMeth, probe:1220
MESSAGE : Error -5099 updating db cfg parm LOGARCHMETH1.

2016-02-26-11.49.05.737000+060 I55606078F683 LEVEL: Error
PID : 4336 TID : 3912 PROC : db2syscs.exe
INSTANCE: DB2IIC NODE : 000 DB :
APPHDL : 0-3032 APPID: *LOCAL.DB2IIC.160209140231
AUTHID : DB2IIC HOSTNAME: DB2
EDUID : 3912 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlfUpdateDbCfg, probe:70
MESSAGE : ZRC=0xFFFFEC15=-5099
SQL5099N The value "" indicated by the database configuration
parameter "" is not valid, reason code "".

DATA #1 : String, 41 bytes
Error updating per-member DB config, rc =

2016-02-26-11.49.05.737000+060 I55606763F1611 LEVEL: Error
PID : 4336 TID : 3912 PROC : db2syscs.exe
INSTANCE: DB2IIC NODE : 000 DB :
APPHDL : 0-3032 APPID: *LOCAL.DB2IIC.160209140231
AUTHID : DB2IIC HOSTNAME: DB2
EDUID : 3912 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlfUpdateDbCfg, probe:71
DATA #1 : <preformatted>
each_param->token: 822
each_param->ptrvalue: disk:z:\db2backups\archive_logs\OPNACT
each_param->flags: 0
CALLSTCK:
[0] 0x00007FFF0C64132B pdLogPrintf + 0x3FB
[1] 0x00007FFEE724F1E8 sqlfUpdateDbCfg + 0x2C18
[2] 0x00007FFEE724C4B9 sqlfDispatchDbCfgUpdate + 0x69
[3] 0x00007FFEEC1A59C7 sqlfudb_backend + 0x2B7
[4] 0x00007FFEEC18F06C sqlesrvr + 0x9FC

People who like this

  0
Comment
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster

3 answers

  • Sort: 
110000Q8NJ gravatar image

Answer by mor (391) | Feb 26, 2016 at 10:16 AM

It is complaining that the path z:\db2backups\archive_logs\OPNACT does not exist.

Verify that Z: is mounted, and the full path exists with correct permissions, before any database activates...

Comment

People who like this

  0   Share
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
06000283EN gravatar image

Answer by 06000283EN (0) | Feb 26, 2016 at 12:39 PM

Hello Mor,

Thanks, .... I made a mistake in the path.......

Z:\Db2backups\DB2IIC>db2 "UPDATE DB CFG FOR OPNACT USING logarchmeth1 disk:z:\db2backups\DB2IIC\archive_logs\OPNACT"
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

So for now the next step is get the config. as we used it on the old DB2 environment ( Windows 2008 R2 with DB2 10.1 FP2 ) to
write archive logs to a a server share directly.

Z:\Db2backups\DB2IIC>net use \\scvbus\db2backups
The command completed successfully.

Z:\Db2backups\DB2IIC>set | find "USERNAME"
USERNAME=db2iic

So we are running the DB2 instance onder the local user DB2IIC, the same user also exists locally on the scvbus server.

I can open shares from within the explorer view without entering any credentials but setting the LOGARCHMETH1 to this
location doesn't work anymore? We were able to configure it like this in the old setup.


Does this have something to do with Windows 2012 R2?

Thanks.

Cheers, Marco

Z:\Db2backups\DB2IIC>db2 "UPDATE DB CFG FOR OPNACT USING logarchmeth1 disk:\\scvbus\db2backups\DB2IIC\archive_logs\OPNACT"

SQL5099N The value "\\scvbus\db2backups\DB2IIC\archive_logs\OPNACT" indicated
by the database configuration parameter "LOGARCHMETH1" is not valid, reason code "2". SQLSTATE=08004

db2diag.log

2016-02-26-14.31.13.231000+060 I55617902F515 LEVEL: Error
PID : 4336 TID : 3912 PROC : db2syscs.exe
INSTANCE: DB2IIC NODE : 000 DB :
APPHDL : 0-3032 APPID: *LOCAL.DB2IIC.160209140231
AUTHID : DB2IIC HOSTNAME: DB2
EDUID : 3912 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlfVerifyLogArchMeth, probe:1220
MESSAGE : Error -5099 updating db cfg parm LOGARCHMETH1.

2016-02-26-14.31.13.231000+060 I55618419F683 LEVEL: Error
PID : 4336 TID : 3912 PROC : db2syscs.exe
INSTANCE: DB2IIC NODE : 000 DB :
APPHDL : 0-3032 APPID: *LOCAL.DB2IIC.160209140231
AUTHID : DB2IIC HOSTNAME: DB2
EDUID : 3912 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlfUpdateDbCfg, probe:70
MESSAGE : ZRC=0xFFFFEC15=-5099
SQL5099N The value "" indicated by the database configuration
parameter "" is not valid, reason code "".

DATA #1 : String, 41 bytes
Error updating per-member DB config, rc =

2016-02-26-14.31.13.231000+060 I55619104F1624 LEVEL: Error
PID : 4336 TID : 3912 PROC : db2syscs.exe
INSTANCE: DB2IIC NODE : 000 DB :
APPHDL : 0-3032 APPID: *LOCAL.DB2IIC.160209140231
AUTHID : DB2IIC HOSTNAME: DB2
EDUID : 3912 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlfUpdateDbCfg, probe:71
DATA #1 : <preformatted>
each_param->token: 822
each_param->ptrvalue: disk:\\scvbus\db2backups\DB2IIC\archive_logs\OPNACT
each_param->flags: 0
CALLSTCK:
[0] 0x00007FFF0C64132B pdLogPrintf + 0x3FB
[1] 0x00007FFEE724F1E8 sqlfUpdateDbCfg + 0x2C18
[2] 0x00007FFEE724C4B9 sqlfDispatchDbCfgUpdate + 0x69
[3] 0x00007FFEEC1A59C7 sqlfudb_backend + 0x2B7
[4] 0x00007FFEEC18F06C sqlesrvr + 0x9FC

Comment

People who like this

  0   Share
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
110000Q8NJ gravatar image

Answer by mor (391) | Feb 26, 2016 at 05:56 PM

Same reason code 2: the new UNC path either does not exist or is not found bu the logon-account used by the DB2-instance.

Fix that first.

If the UNC path exists and the localuser acting as the "Log on As" for your DB2-instance can create files (from remote) on it and delete files and write files on it then DB2 should be happy (as long as you verify that the services.msc shows that your DB2-instance has '"Log on As" with a correct value).

If that fails with the same error, try running the DB2-instance account with a domain account (where both of the Windows servers are either in the same domain, or have appropriate trusts) and that domain-account can create/read/write/delete files on the UNC path.

Comment

People who like this

  0   Share
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster

Follow this question

68 people are following this question.

Answers

Answers & comments

Related questions

DB down situations 3 Answers

DB2 Backup size files 3 Answers

Tablespace in Backup Pending after db2 load 3 Answers

Restore database to a different instance 9 Answers

DB2 LUW Restore - How can I dynamically determine the latest backup image copy for restore purposes? 4 Answers

  • Contact
  • Privacy
  • IBM Developer Terms of use
  • Accessibility
  • Report Abuse
  • Cookie Preferences

Powered by AnswerHub

Authentication check. Please ignore.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • API Connect
  • Analytic Hybrid Cloud Core
  • Application Performance Management
  • Appsecdev
  • BPM
  • Blockchain
  • Business Transaction Intelligence
  • CAPI
  • CAPI SNAP
  • CICS
  • Cloud Analytics
  • Cloud Automation
  • Cloud Object Storage
  • Cloud marketplace
  • Collaboration
  • Content Services (ECM)
  • Continuous Testing
  • Courses
  • Customer Experience Analytics
  • DB2 LUW
  • DataPower
  • Decision Optimization
  • DevOps Services
  • Developers IBM MX
  • Digital Commerce
  • Digital Experience
  • Finance
  • Global Entrepreneur Program
  • Hadoop
  • Hybrid Cloud Core
  • IBM Cloud platform
  • IBM Design
  • IBM Forms Experience Builder
  • IBM Maximo Developer
  • IBM StoredIQ
  • IBM StoredIQ-Cartridges
  • IIDR
  • ITOA
  • InformationServer
  • Integration Bus
  • Internet of Things
  • Kenexa
  • Linux on Power
  • LinuxONE
  • MDM
  • Mainframe
  • Messaging
  • Node.js
  • ODM
  • Open
  • PowerAI
  • PowerVC
  • Predictive Analytics
  • Product Insights
  • PureData for Analytics
  • Push
  • QRadar App Development
  • Run Book Automation
  • Search Insights
  • Security Core
  • Storage
  • Storage Core
  • Streamsdev
  • Supply Chain Business Network
  • Supply Chain Insights
  • Swift
  • UBX Capture
  • Universal Behavior Exchange
  • UrbanCode
  • WASdev
  • WSRR
  • Watson
  • Watson Campaign Automation
  • Watson Content Hub
  • Watson Marketing Insights
  • dW Answers Help
  • dW Premium
  • developerWorks Sandbox
  • developerWorks Team
  • Watson Health
  • More
  • Tags
  • Questions
  • Users
  • Badges