The discipline of Operational and Architectural Management of Database Systems.
1
vote
0answers
62 views
What is the future for system and database administration [closed]
Let me present myself for better understanding of my challenge. I love coding, it's been 5 years that I've been in a company as software developer. But for the past 3 years I've been quite pushed into ...
1
vote
0answers
38 views
Database Timeout Error from VB Application
Recently we are receiving so many database timeout error from different servers
we are using vb application -- which will use ODBC connection to connect database - here no problem
when we run the ...
1
vote
1answer
66 views
Create database on new partition
I use postgresql 9.1, on ubuntu 12.04. I had installed the depot package.
I have added a new partition to my system, and I would like to create a postgresql database on this partition ( which will be ...
1
vote
1answer
159 views
how to add attachment(text file) to database mail?
I have scenario
Daily i run a sql job to apply a new updates to one table - this job will create one text file daily - text file contains all new updates
I can send a mail to client that job is ...
1
vote
1answer
75 views
Database Designing for a Ecomerce website
I am new to database designing. I am designing a database for an eCommerce website, there is a lot of products to be updated, but while designing for product specification table I do not understand ...
1
vote
0answers
78 views
SSMS produces error if query returns too many rows
We are having an issue with a server that we linked to our sql server 2012 instance.
The server that we linked through an odbc or oledb connection is Pervasive SQL.
Selecting from the linked server ...
1
vote
1answer
394 views
unable to login oracle as sysdba
I just got 11gR2 running and was able to conn as sysdba. I shutdown and started up the database to mount a new pfile. Now, I cannot login as sysdba. My parameter for password file is:
...
1
vote
1answer
217 views
MySQL Tables crashing randomly
This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this?
How do I keep MySQL tables from crashing and MySQL from crashing?
Repairing USR_wp537
...
1
vote
0answers
81 views
Database instance keeps restarting
From the past few days, our MySQL database instance has crashed and had to be restarted a few times. My MySQL version is 5.1.57-log. The CPU and memory usage was way below 50% during the crash time. I ...
1
vote
1answer
91 views
Regularly import tab-seperated log file to MySQL
I'm looking to keep arpwatch entries in a MySQL database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
1
vote
2answers
688 views
Unable to mount oracle instance
I am trying to shutdown the system, then I want to mount it. I have tried this:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
...
1
vote
1answer
269 views
How to prevent high memory, CPU and time consumption by MySQL restore?
I have a local test machine with 2 GB RAM and a dual core processor.
I imported a dump on that using
mysql -uuser -psecret < script.sql
script.sql is a 700 MB file which contains a single ...
1
vote
0answers
168 views
Where does a DBA work? [closed]
I want to study for a DBA certification, maybe MySQL or Oracle 11g. I always have worked in small and medium companies. I wonder, in a big company like Google or Facebook, Where does a DBA work? in ...
1
vote
1answer
136 views
Dates in openldap acl rules
Is it possible to use dates in OpenLDAP's ACL entries? I'm looking to do something like to * by this/termDate < NOW none by * break
0
votes
1answer
144 views
Do you feel like DBA/DBD Is a “secure Field” still? [closed]
I noticed recently alot of Database jobs/Development have kind been pushed onto general developers, not to mention with NoSQL Solutions (Which IMO are probably a little easier for Non-DBA's to throw ...
0
votes
3answers
137 views
How do I enable READ-only (passive) mode in a particular RDBMS?
As most of you have noticed all StackExchange sites have been under maintenance/recovery a few days ago so they switched on READ-only mode. From their blog I know they used to use MS SQL Server 2008, ...
0
votes
1answer
68 views
What is the maximum number of rows in a clustered index on datetime column?
I would like know what the max no of rows is in a clustered index (non-unique) on a datetime column table in SQL Server 2008R2.
0
votes
2answers
153 views
Restore the latest backup on the database
We have a stored proc which takes the backup from a database to the specified location. Sometimes the backup process runs more than once. It causes having more than one backup set on the same file ...
0
votes
2answers
147 views
How to identify the db orphan mdf and ldf files
I want to identify the orphan mdf and ldf files on the disk and remove them. After searching on the internet, found the script below on MSDN forum. But when I run the script it returns many ...
0
votes
2answers
66 views
what is the best choice from those two tables?
what is the best choice from those tables??
table A : keep DB simple with lower number of tables ... but i will find difficulties if i wanted to extract certain data from column of doses coz it's ...
0
votes
1answer
614 views
DBF file exist while user has been dropped?
I am new to Oracle. I have dropped some users from my database using:
DROP USER username cascade;
The issue is that the .dbf file still exists in the $ORACLE_HOME/dbs/oradata/ directory, which is ...
0
votes
1answer
58 views
How to deny access to see the logins in a database
I create a login in SQL Server 2008 R2, and when that user connects to a database, it can see all the logins in the security logins. Can I deny access to watch the logins of the database?
0
votes
2answers
205 views
Remote database connection problem?
I have two systems with Windows XP. I have installed SQL Server 2005 on a system and tried to use SQL Server Management Studio Express on both to use the database.
I am able to use the database on ...
0
votes
2answers
220 views
DBA to work from home [closed]
I was wondering is it feasible or doable to work from home as a DBA or Database designer/developer or Business intelligence developer.
I have seen developers doing great working from home, but can ...
0
votes
2answers
212 views
Is command BACKUP asynchronous operation
I got strange delays when backed up a group of databases (20 more) in one scope (TSQL) to the same file location.
Is it possible that multiple backup operations are running at the same time? I have ...
0
votes
1answer
118 views
SQL Server primary key create clustered index
I've inherited a database where no primary keys were defined on the tables. There are also no clustered indexes assigned to the tables.
If I perform an alter table to assign a primary key will this ...
0
votes
1answer
144 views
Difference between chained and migrated rows
What is the difference between chained and migrated rows? Also what query should be used to display these rows? (I'm using Oracle 11gR2 database)
0
votes
1answer
88 views
How are transactions logs inserted?
I have an ms-access database at work that has a table that's a transaction log.
The table contains the following fields:
Date - The date the transaction took place.
Table_Name - Name of the ...
0
votes
1answer
368 views
WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
The scenario
Two systems(not server) running PHP and PostgreSQL with the following versions
Fedora 15:
PHP
PHP 5.3.13 (cli) (built: May 9 2012 14:38:35)
Copyright (c) 1997-2012 The ...
0
votes
3answers
1k views
What is the purpose of having a table NOT LOGGED INITIALLY
I came across this recently. When defining a table in DB2 LUW (at least 9.5 or higher), you can define it as NOT LOGGED INITIALLY.
Example from the book I read:
CREATE TABLE products (
productID ...
0
votes
1answer
75 views
What are the challenges of administrating an International stock trading database?
I am a student, and have a question for an assignment:
What problems and challenges do database administrators face when designing systems to trade international stocks in real time and 24 hours a ...
0
votes
1answer
18 views
Syntax error when trying to import database from two PostgreSQL databases
Following on from this prior question, I'm trying to export a database from one server and put it on another using phpPgAdmin. My process is like this:
select the database in server 1 and hit the ...
0
votes
2answers
55 views
Oracle database uses wrong parameter file
When I try to startup my Oracle database I get the following error:
LRM-00109: could not open parameter file '/opt/app/oracle/product/11.2.0/db_1/dbs/initjicdbaex.ora'
The /dbs directory in my ...
0
votes
1answer
37 views
PostgresSQL: Cannot get to console under different user name
I normally get to the console in UBUNTU by typing:
sudo -u postgres psql
But I need to delete a database owned by a different user.
When I type:
sudo -u username psql
It tells me "database ...
0
votes
1answer
533 views
How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
I´m new to SQL Server administration.
I´d like to create automatically backup database every sunday night, if there was any change in previous week (if not, backup is unnecessary).
Is there some way ...
0
votes
1answer
138 views
Data storage in innodb
I am new to mysql administration and I came to know about the data storage in myisam is through .frm, .myd and .myi. I could not find the data storage mechanism in InnoDB rather than its storage in ...
0
votes
2answers
230 views
Is there data visualisation tool for postgresql which is capable of displaying inter schema relations as well?
Operating system used is linux. I have tried Navicat and SQL Power Architect. They did display relations between tables in the same schema. I have some foreign key constraints which reference tables ...
0
votes
1answer
145 views
RAID vs Replication [closed]
I'm kind confuse about it, can some one give me a hand with this...
Differences.
Which one is better.
Which one do you use and why?
Personal Opinion and advise.
0
votes
1answer
48 views
Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication
I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber.
...
0
votes
1answer
182 views
Look for software that can convert sql (mysql) to erd
I would like to have an ER Diagarm in phpmyadmin, however, its graph is not up to my expectation, the graph has no relationship indicator (1-1) (1-m) etc at all.
So i am wondering whether there is a ...
0
votes
1answer
256 views
sql server express lan
I want to know if sql server (express) need to have always admin right on a computer.
I ask my company to have a version on my pc, but I need a tech to install it because I dont have admin right.
...
0
votes
1answer
3k views
Maintenance plan delete backup
I succeeded in making a backup through maintenance plan.
All I need now is to find how to delete a folder (containing old backup) through the same maintenance plan.
0
votes
2answers
130 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
2answers
152 views
MySQL Table not repairing
Table info:
Database name: user_motiva
Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD
when I do a mysqlcheck -r --all-databases it gets hung on that table even if you ...
0
votes
1answer
186 views
Unable to change engine to MyISAM in MySQL
I have installed MySQL 5.6.10 on Mac OS X 10.6.5. My issue is that MySQL is using InnoDB as its default engine.
I have checked following engines are supported in MySQL:
show engines\G
...
0
votes
1answer
157 views
mysql fine tuning: open_tables, opened_tables
I'm a novice to database administration and have been depending on forum suggestions and answers to help resolve my database hang ups and too many connections errors; I've managed to reduce the ...
0
votes
1answer
303 views
Achieve log transfer to standby (Data Guard)
I am not able to transfer my archive logs from primary to standby. I executed the following query:
archive log list
Database log mode Archive ...
0
votes
1answer
103 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
56 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
648 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' \
...
