05-19-16, 15:32 #1Registered User
- Join Date
- Jan 2007
Unanswered: SQL Server DBA new to DB2, basic questions
I am an experienced SQL Server DBA but have been suddenly thrust into administering a DB2 instance and am struggling a bit (a lot ) with getting going. Looking for assistance to jump start my admin capabilities. Any help is most appreciated!
Environment: Windows Server 2012 R2 Standard, DB2 for LUW v10.5, 1 user database created by a 3rd party application
The first order of business is backup/recovery...
Being a SQL Server guy, i fired up IBM Data Studio 4.1.2, connected to the instance/db just fine (i think) and am trying to take the equivalent of a SQL Server Full backup of the db2 db. However, in Administration Explorer, I right-click the db to select Backup and Recovery per some instructions I found, but that menu item is missing and so are others. Any ideas why?...
Could it be permissions related - I am connected using my domain credentials which has membership in both the local admins group and the DB2ADMNS group.
Perhaps it's software related? maybe wrong version or something like that?
Some general questions...
- Is Data Studio akin to Mgmt Studio for SQL Server? Should i be able to accomplish the same level of administration using data studio as mgmt studio?
- Or, should i bag data studio altogether and shift my focus to the various cmd line tools provided with db2?
- How do I find where the physical database files are? What sort of recovery/logging is setup?
I guess that's it for now. Thanks a ton for anyone willing to help this DB2 newbie get on his way.
05-20-16, 02:15 #2Registered User
Provided Answers: 2
- Join Date
- Apr 2008
- Iasi, Romania
2. Yes. db2cmd must be your friend
3. You should check instance config and database config properties. Search into docs for GET DBM CFG and GET DB CFGFlorin Aparaschivei
DB2 9.7, 10.5 on Windows