The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

0
votes
1answer
131 views

How database buffer pool work?

For example we have 2 scenarios: Scenario 1:- We have very small buffer pool size of 100MB. My query data is 500MB. Does the system keep 500MB query data in RAM such that a new ...
0
votes
1answer
112 views

Notification when the status on sql server replication is “Not Running”

We have a lot of replications set up. Sometimes for some reason, the status of the replication changes to "Not Running/Expired Soon or Expired". Could you please let me know if there is a way we can ...
0
votes
1answer
123 views

Indicators for right balance of the number of DB2 instances per AIX LPAR

I have a question that has been bugging me, but I just don't know how to validate it. We run DB2 LUW on AIX in our shop. Our AIX is currently at 7.1. Our DB2 is at 9.7 FP 4 for most installations and ...
0
votes
1answer
943 views

Best Innodb Buffer Pool Size for 8GB RAM?

I found out that my MySQL server is configured with only 128MB for innodb_buffer_pool_size. That is not enough considering that I have a 8GB RAM server. It hosts MySQL server and an Apache/Catalina ...
0
votes
1answer
141 views

Copy database from one mysql sever to another mysql server

Following are the details of the database and server: Server1: Host Name: abc Port Num: 01 database: test Server2: Host Name: xyz Port Num 02 database: spareparts userid: spts password: abcdefgh@123 ...
0
votes
2answers
230 views

Restore Database with Multiple Restore commands

For automation, I have to dynamically construct the restore commands and thus I have created a script. A .bak file is created on a remote server and I receive it daily. The script builds the restore ...
0
votes
2answers
274 views

Cannot find .bak in a backup file [closed]

My database backup works well or you can see the backup in the backup file. But the backup has no format of a backup file. I mean you cannot see the .bak associated with it, therefore unusable by ...
0
votes
1answer
1k views

What are the problems with sharing an Access database through online storage service, like Dropbox?

I have a desktop database I created in Access. I'd like to share the database with a single collaborator, who can have full privileges to the database (table access). However, my collaborator is much ...
0
votes
2answers
1k views

MySQL: How to fetch nth level child menus of a parent menu

I have a menu which is parent of multiple menu items and each child menu has their own child menus. This pattern is continued till 5-6 vertical hierarchy level. I don't want to write a query which ...
0
votes
2answers
3k views

MySQL - HOWTO speed up slave replication on large database / Quickly spawn slave?

We have a large mysql database (about 100GB on disk) that we would like to spawn a slave for. Our typical process for creating a slave is: Create a slave server Load in a mysql dump of the master ...
0
votes
1answer
43 views

Max function and group by getting differenet count [closed]

Statement 1 : Select Load_Date , Count(*) Last_Count From <Table_Name> group by Load_Date; Statement 2 : Select max(Load_Date) , Count(*) Last_Count From <TABLE_NAME>; Statement 1 ...
0
votes
1answer
2k views

How many tables will be there in Magento 1.8 [closed]

I just started using Magento with 1500 products and I saw the DB size is about 150MB and when I looked at the tables, the count is 250 tables. Is it normal? Should I worry about anything? I host ...
0
votes
1answer
153 views

PHP SQLite Admin is running on PHP 5.4

I tried phpsqliteadmin But it doesn't seem to work anymore on PHP 5.4. There are several alternatives, but none of them seems to be "The One" that is maintained and widely used. Is there a standard ...
0
votes
1answer
149 views

What is the strategy of query evaluation in DBMS when Limit is used in query?

I have following tables in database post(post_id , user_id , post_text , parsed_text) ; Comment(comment_id , post_id , user_id , comment_text) ; friend(id , user_id , friend_id ) ; group (id , ...
0
votes
3answers
316 views

Large RAM use after import database - ubuntu server

My new VPS has 4GB of RAM. Before importing database system use about 1.2 GB of RAM. When I import into the database, using 250 MB SQL file, 25000 tables use of RAM goes to 97%, htop showing 3302 mb ...
0
votes
1answer
488 views

Pentaho 4.4 Database connectivity issue

I am getting the following in one of my transformations. I am trying to extract data from SQL server and pushing to mongodb. 2014/04/03 13:11:10 - EMPLOYEE TABLE Input.0 - linenr 700000 2014/04/03 13:...
0
votes
1answer
583 views

How should I config the my.ini(or my.cnf) file for mysql?

Thanks for taking your time to look at my question, and I hope that you can help me with this. I have a Windows Server 2012 server, it has: Memory : 3840MB Ram Processor: Intel(R) Xeon(R) CPU E5-...
0
votes
2answers
1k views

Recovering mysql innodb table from table.ibd backup file

Just practising DB disaster recovery. As per our back up policy, we do complete disk image back ups every half an hour (on our slave server). Now for a scenario, where some how a table has been ...
0
votes
1answer
681 views

how many 'text' column a table could have in mysql? I have this error “Row size too large (> 8126).”

I'm working on a application which is kinda complex to explain how it works. But this is the situation I'm in, ------------------------------------------------------------------------------ FIELD1 (...
0
votes
1answer
1k views

What is a bucket in database? [closed]

I was implementing a code that involves a database and buckets. Just wanted to ask what is bucket and can someone describe it with an example? Thanks!
0
votes
1answer
69 views

Database Designing Issue

I have a database having Millions of records in three tables. Now i want to split these three tables in multiple tables to reduce redundancy and data duplication. A lot of records(Persons) have ...
0
votes
3answers
121 views

Applying data changes from one database to another

I have an application running on Oracle 9i database and I was looking for something more practical to deploy data changes (not schema changes) from the development database to production. Currently I ...
0
votes
1answer
411 views

can't connect to postgresql with md5 [closed]

I can connect to db with trust, but it is not letting me to connect with md5. It says : "password authentication failed for user "postgres"" Here what I have in pg_hba.config host all all 192.168....
0
votes
1answer
398 views

Which index types do not support online index rebuilds?

In SQL Server 2012 Enterprise Ed., which index types do not support online index rebuilds? and why? and which activity-operations can prevent online index rebuilds?
0
votes
2answers
966 views

SQL Server 2012. Update second table based on input from first table

I have two tables in two databases: Table01 in Database01 and Table02 in Database02. Both tables have a column called UserID. The UserID column is created when the user creates a new account on the ...
0
votes
1answer
8k views

Oracle 11g increasing shared pool size and java pool size

i need to install/configure oracle jvm on 11g. to be able to install same i need to increase the size of shared_pool_size and java_pool_size. i have automatic memory management enabled. my ...
0
votes
1answer
1k views

Oracle Character set identification

In the given export(Normal Export) log file i see following: Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set Is this multi-byte or single byte database char-set. Can you ...
0
votes
2answers
13k views

SQL Server Management Studio - connection with SQL Server database engine

This question is in regards with SQL server 2005 and 2012. I have a database server with two instances of SQL Server. Through SQL server management studio I was able to connect to both instances by ...
0
votes
1answer
34 views

prepare stmt is not working

set @sqlt = concat("select", @rowname_date," from syslog_data.syslogs_index_1 "); prepare stmt from @sqlt; execute stmt; deallocate prepare stmt; gives me a eeror 1064 in the prepare statement? Any ...
0
votes
1answer
226 views

Does failed task considered to be run to completion in SQL Server maintenance plan terminology?

The replies to my previous question: "How to specify a SQL Server maintenance plan subtask to run unconditionally on success or failure of preceding tasks?" answered me that I should change "...
0
votes
1answer
3k views

DB2 9.7 LUW - How do I SET SESSION_USER when I am DBADM,SECADM?

Based on a previous question I have asked, I am attempting to work on a solution as recommended by mustaccio's answer, whereby I have another ID to create my DDL objects. I have been trying to follow ...
0
votes
1answer
2k views

How do you get the graph plugin for Squirrel SQL?

I installed Squirrel SQL and the website claims the Graph plugin is part of the install. It is not available nor is it in the jar. How do I get the graph plugin?
0
votes
1answer
693 views

How to revoke DBADM and clean up any related objects from DB2 LUW

This question has started because of us taking copies of production backups and restoring them into lower environments (with scrambled data of course) for developers to practice and/or debug against. ...
0
votes
1answer
596 views

Where to install Oracle client software on SharePoint 2010 Server

We have our ASP.net web application hosted on a SharePoint Server 2010. Our application uses oracle database to save and retrieve data.For our application to work on SharePoint server we need to ...
0
votes
1answer
484 views

Security Concerns of SQL Server Express for Web e-Voting web application

I am building a database driven web application. The web application is basically an E-Voting website, where users can register and vote on things that concern their community ... etc. The database ...
0
votes
1answer
3k views

Plugin 'FEDERATED' is disabled

Im trying to start Mysql using easyPHP : the response is an alert window to a log file. The main error is <-- Plugin 'FEDERATED' is disabled -->. Through my research on internet i found that the ...
0
votes
1answer
507 views

replication breaks after upgrading master

I have a set up of replication with master 5.1.30 and slave 5.5.16 and the replication is working good Now i have upgraded mysql master to 5.1.47 As far as i know we have to turn off the log bin ...
0
votes
2answers
4k views

Secure Linked Server - Non privledged user possible? Registry corruption?

Is it possible to use a non privledged Windows domain account to impersonate itself in a linked server? And why would it be unable to read the registry for available network protocols? Overview: ...
0
votes
1answer
3k views

TSQL query for viewing start/end of all SQL Agent jobs yesterday

See this related query: What's a good tool for visualizing SQL Agent jobs? I'm not after a visual tool however, since I am looking to build my own visualisation. This is my starting point, but ...
0
votes
1answer
109 views

Is Index Used for This Query

If so, which one? How do we know? I have 3 indexes in a query. Actually only the first 2 should be useful { "v": NumberInt(1), "key": { "LongitudeLatitude": "2d", "Prominent"▼: ...
0
votes
1answer
4k views

What is going wrong with postgresql initdb? Why is the `UTF-8` encoding not getting enforced?

I am using PostgreSQL 9.1. Trying to enforce UTF8 encoding as default. This is what I am doing. service postgresql initdb -E 'UTF-8' \ --lc-collate='en_US.UTF-8' \ --lc-...
0
votes
1answer
806 views

Unable to restore database in Oracle 10g

I created a database backup using the expdp command in Oracle 10g. The backup appears to be created successfully. However, while restoring using impdp command I get the following error message. ...
0
votes
1answer
635 views

What are commonly used database types? [closed]

There are a lot of database types. Can you list a list of the top classification of databases commonly found in schools and offices? Any help is appreciated. Hope to see compressed and summarized type ...
0
votes
1answer
17 views

What is effective way to delete duplicate records based on multiple columns in MySQL?

I have a table named users having approx 70 Million records, out of which I guess 10 Million is duplicate. How to remove those 10 Million records keeping one copy of that. Two records are said ...
0
votes
0answers
12 views

Oracle DB refresh on 11g using 10g Cold backup

I am a sql dba, I am having only a little knowledge on Oracle. looking for help regarding oracle db restore. I am having an Oracle 10g cold backup, i need to restore this on Oracle 11g setup, can you ...
0
votes
0answers
25 views

Top Recommended Books/Courses For Learning Mid-Advanced Database Programming Beyond Basic CRUD Operations [on hold]

I have been a SQL DBA for the past two years and am looking to learn more indepth database programming to up my skill set and make me more attractive to potential employers. Currently with my day to ...
0
votes
0answers
32 views

SQL Server Memory Configuration [duplicate]

My Server has Total RAM 200GB. I have set 80% of total RAM for SQL Server as it needs more memory. Just want to know if there is any fixed number or method to finalise amount of memory to be set for ...
0
votes
0answers
36 views

Temp DB configuration

My TempDB disk size is 100GB. Out of that I have made below split: 80GB/8 = 8 Data files. 15GB for Log file. Remaining 5GB I have left for autogrowth for last eight datafile and log file(...
0
votes
0answers
60 views

What are PDE files and how can I use them?

I've got a legacy DB which was given to me as a collection of PDE files. I've googled around and didn't come up with any useful information. Saw this question: Import .pde file on PL/SQL Developer .....
0
votes
0answers
17 views

Mix mode auth password,is it sa password?

During SQL Server 2014 Installation,I have set up Mixed Mode Authentication and given a password for it.My question is when I set Mix mode,did I set up password for SA login.So if want to use SQL ...