View Full Version : IBM DB2
Pages :
[
1]
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
- makefile
- Updating an indexed column with the same existing value
- SQL0104 on Update with Fetch
- Use of OLAP function
- Should system temporary tablespaces generally be on automaticstorage?
- u just click u get some dollars
- How do I concatenate strings from a column into a single row in DB2
- Online reorg & log full condition
- Trigger: After Delete ... for each row behaviour
- Views and union...
- diag.log.sav
- Can we create a sample database on the app dev client
- Explain of update-statement without commit
- What the problem with VARCHAR_FORMAT?!?!?!
- Confused about memory parameters
- JOIN between 2 tables. No foreign key, just ranges
- Online backup locking out processes...........
- Prepared statement too long
- Lock Table and auto commit
- A blog to lift the fog on Dataphor
- any documents for 32 bit and 64 bit stored procedure conversion ?
- Re: SIGNAL ON DELETE AND CAPTURE
- DB2 DBA required in Vancouver, BC (Contract)
- Re: SIGNAL ON DELETE AND CAPTURE
- No access to the SNAPDYN_SQL view
- Stored procedure Slo
- How to "LOAD COPY NO" without backup ?
- Query doing table scan when added simple predicates
- new dba blog
- Is this an Invalid option? | db2pd -apinfo
- NOT ENFORCED RI - what optimization opportunities are missed?
- SQL0746N: Routine violated nested SQL statement rules when attemptingto perform operation "MODIFY" on table
- Uniqueness checking overhead
- setting optimization level in stored procedure
- db2diag -g db=DBNAME,instance=instname
- FLUSH PACKAGE CACHE DYNAMIC
- Load performance on AIX w/ SAN
- Last access time for index
- dsn1copy uses dynamic allocation for multiple pieces
- Error using old table() in UDF
- "WITH RS USE AND KEEP UPDATE LOCKS" An unexpected token
- 64 bit encoding in CLOB
- sqlqgRouter_conn_lost_cleanup in db2diag.log
- Linux + DB2 + php
- Co-releated Update Statement Tuning
- Overriding database collation in queries for LIKE operators
- Find SQL in Stored Procedures
- Getting rid of kuddb2
- IBMLDAPauthserver/IBMLDAPgroups, DB2 v. 9.5 ppc-Linux
- Migrate schedules from one instance to another in V9.5
- runaway sqls
- SQL PROCEDURE on the iSeries
- DB2 - forcing a table to cache all data in the buffer pool.
- DB2_USE_ALTERNATE_PAGE_CLEANING and HADR
- db2 doesn't start on windows2003(update from win2000)
- After adding a tablespace container: DMS rebalancer is active
- More DB2 Vista NewBee questions
- HADR - AIX
- NewBee Express-C Questions
- How to debug sqc program
- Backup with include logs option
- Problem with calculate difference between rows
- capturing optimization level used for certain sql
- How to get database size in DB2?
- index usage?
- Troubles with Start database manager
- Optimal Method for Getting Max Value
- PCML and DEXA
- Max table or database size?
- db2 questions
- V9.5 HADR On AIX
- stored procedures dependencies
- Query for selecting NON DUPLICATE ELEMENTS in a table
- difference in performance in two environments for same sql
- Re: SQL0104N An unexpected token error
- difference in performance in two environments for same sql
- DB21034E with triggers
- dynamic sql - prepare statement
- Unique values in column
- Unicode arguments in posstr(), locate() and LIKE
- Restore Questions (32 vs 64 bit)
- DB2 federation problem when reconnecting to a remote federated AS/400
- db2stop taking time
- Restrictions for SSL on db2 express c luw?
- DB2 Database Administrator
- DATABASECAPACITY and SMS tablespaces
- Health Monitor Invalid history version in header
- Possible to manually mark routine packages as inoperative in DB2LUW?
- DataServices World features Universal Services, SOA, WOA and cloudcomputing (San Jose, November 20, 2008)
- SQL3255 on DB2 v9.1 Win32 with db2move
- issue on
- 9.5 LUW, pointers on running 32 bit client against 64 bit server?
- Question on SQL-based Administrative Task Scheduler
- Yielding timeslice
- Get the last day of previous business quarter
- NO FILE SYSTEM CACHING - Automatic?
- Sigh, Undocumented error - SQL30082N, RC=22
- confusion about cardinality in explain plan node on compressed table
- confusion about cardinality in explain plan node on compressed table
- Re: MDC vs. cluster index: which to use?
- backup with multiple targets
- Add a partition to a table that already has partitions
- Supress SQL0347 (CTE may contain infite loop)
- update from select
- SQL30082N Attempt to establish connection failed with security reason"24" ("USERNAME AND/OR PASSWORD INVALID").
- =?windows-1252?Q?Training_Program_for_the_IIBA=99_CBAP=99_Ce rtificati?==?windows-1252?Q?on_examination_=28BABOK=AE=2DVer_1=2E6=29_b y_CBAP_Certified_faculty_w?==?windows-1252?Q?ith_100=25_Job_offer?=
- Set Encryption password and SQL20143N
- Yellowfin Enhances Business Intelligence Reporting forTelecommunications
- CTE is not supported by db2advis
- PHP5 and DB2 9.5
- query help
- reset monitor switches while capturing snapshots with sql functionsor views
- DB2 and Websphere MQ transaction coordination
- Solaris 10 Database bufferpool problem
- How to determine the isolation level of incoming queries.
- Unique Opportunity To Join The Elite Group Of Project ManagementProfessionals
- calling stored procedure from Perl code
- Syntax error when creating user mapping in DB2 (Data Federation)
- actual/estimated cost/cardinality of query plan
- progress bar for runstat?
- DDF Security?
- All about memory
- HADR Status
- truncate tables in stored procs?
- How to Give Operating System Security in db2 if not configured duringinstall ?
- How to view the special registers in db2
- Block Comment Confusion ...
- DB2 - check if product installed on Solaris/AIX/HPUX
- DSNL013I & DDF, DB2 9.1
- DB2 9.5 SQL Procedure Developer exam 735 prep, Part 2: DB2 SQL Procedures
- REORG INPLACE -964 ERROR
- INPLACE REORG problem
- Kernel parameters for db2 v8.2 on Solaris 10
- DB2 Client Upgrade Questions ....
- HAVING and WHERE clauses: Performance considerations in SQL
- SQL help
- Newbie - Partition setup multiple tables
- Last DB2 to run on Solaris 8
- LOAD with COPY
- Advs & disadvs of Self Tuning Memory Management feature of DB2 v9.5
- Collecting DB2 performance results for my thesis paper
- Just checking
- Dynamic sql statement called in a stored procedure SP
- Please explain query intervals output
- Variables in SQL???
- outer join table filtering
- SqlException Unsupported ccsid, encoding, or locale: "Cp037"
- why is NULLID.SYSSH200 executing so many times
- Leading Zeros
- multiple databases in one instance
- ******GOD OF GIFTS 4 U*********
- IF Exists Bad Parser
- Re: Include all columns in an unique index
- Re: DB2 Container behaviour on EMC DMX 3 San.
- db2 V9.5 SQL1084C
- Re: Include all columns in an unique index
- Why is my static SQL dramatically faster than dynamic?
- IXF Column Descriptor Record
- Re: Include all columns in an unique index
- Db2 v9.5 - Undefined Symbol while creating an instance
- Merge statement: Index on source table
- Multiplexed Connection
- Re: flush package cache dynamic executed from client.
- Self tuning bufferpool
- Self tuning bufferpool
- regarding RAM size and db parameter
- Help with query on sparse timeseries data
- Net Search Extender Throws Confusing Error
- Dropping indexes on a partitioned table
- Requirement - Database Architect - State of Oregon - 6 months
- Changing the DB2 Interface Language under Windows
- Does V8 of DB2 zOS supports
- db2 tablespace restore
- db2 table space restore
- Interview Type Question
- Rows in IXF file
- Yellowfin says Java the smart option for Business Intelligence
- Clob variables in stored procedures and SQL10003C
- how to force bind option for JDBC in db2?
- DB2 equivalent to this Sybase syntax
- Call for speakers for DataServices World in Silicon Valley closes September 26, 2008
- REORG REPLICATED TABLE
- MQT cannot be used for queries with parameter markers?
- Project Management 2.0 !
- Primary Key error wrong number of qualifiers
- DB2 9.5 equivilent of alternate fixpack
- how to ensuring MQT freshness
- SQL0101N The statement is too long or too complex. SQLSTATE=54001
- DB2 UDB LUW full time positions in California
- V9 client accessing V7.2 server
- SQL27984W - Some information has not been saved (import create mode)
- Delete and concurrency problems
- DB2 Consultants required at Bangalore
- DB2 Consultants required at Bangalore
- Temporary table issue
- Problem using/naming subquery
- db2 hash functions
- Use of inequality in where clause
- query on query plan and MQT
- Type 3 driver definitely dead in DB2 V9?
- Need help to replace OLAP
- db2gcf -k, Why is it used?
- NEWLOGPATH and folder NODE000
- DB2 Host variables - PL/1 locator reference
- Best way to create a table
- load and generatedoverride
- Help with rollforward through most current active logs
- DB2 hangs on USEREXIT failure.
- Archival logging and USEREXIT BEHAVIOR.
- Statistics on temporary tables?
- why this 2-column index not used
- Enforcing one-to-many relationship in an existing join table
- LUW generation 8 -> 9.1 or 9.5 experiences?
- Can constraint replace a trigger?
- lowering HWM
- db2 design advisor giving error SQL0180N The syntax of stringrepresentation of a datetime value is incorrect
- IDUG North America 2009 - Denver (May 11-15, 2009) - Call for
- QUESTION: Task Center job won't complete
- Re: How to fix duplicate SSN without table recreration?
- Potential abolition of leap seconds - USNO impact survey
- How to learn IBM-DB2
- Can we create UDF using View instead of table
- what is DB2INSTDEF
- default timestamp value and performance
- DB2 taking a long time to start archiving logs
- SQLCACHE_SNAPSHOT function returns no records.
- db2ckpwd not running under root
- Re: select in a stored procedure call
- question: multiple row insert vs. merge
- deleting backups with db2adutl and meaning of keep parameter
- Generate 'Create database' statement
- set write suspend on database takes multiple hours
- Location Intelligence where to from here?
- How calculate date/time difference in DB2
- Filter Factors when using Parameter markers?
- isolation levels and locks
- Array Insert x db2Import
- what wrong with my UDF use?
- Re: Reg: Owner for Declared Global Temporary tables
- remove DB2 Connect Server ?
- FP2 Vista cannot configure default instance
- Do you know how I can monitor z/os DB2 activity from a unix/windowsmachine?
- DB2 RTCL for linux
- ONLINE RESOURCE FOR HELP DESK SOFTWARE
- Create Database with RESTRICTIVE Option
- Software Problem resolution
- Query plan / table partitioning
- Re: Statements with 2MB size
- Large number of reads on sysibm.sysuserauth.
- Re: select rows where
- soliddb db2 sql conformance?
- How to move tables into different tablespace ?
- DPF on 9.5
- Scalar sub query in db2
- Multible inserts in one Trigger - return code -206
- Multiple tables or single table in one tablespace ?
- Temporary Table
- LDAP authentication
- problem in creating a db
- sysproc.snapshot_tbreorg: What does rergo_status value '4' means ?
- Please Help: Insert generating -803 in Trigger
- Re: Recursive Data and Stored Procedure in DB2
- Runstats / OLTP environment
- SQL0101N The statement is too long or too complex.
- tablespace queisced after load fail in partioned db
- Automate Log shipping
- How to replaces 1 with corresponding position
- Project Management Knowledge Base !
- how to get db2 lock waits details
- Range partition overlap
- connecting servers for playing with HADR
- DB2MOVE
- Control Center extension
- Removing a newline character from a VARCHAR
- Moving tables between tablespaces
- Regarding concurrency MERGE x UPDATE
- recursive query - donot repeat the sub path that has already beendiscovered in the tree
- installing db2 connect product on a machine with db2 ese alreadyinstalled
- How to access DB2 using DataSource?
- DB2 on AIX - Authenticate against Active Directory
- UPDATE CURRENT OF CURSOR
- Can't view tables through Control Center
- db2 get snapshot for dynamic sql output question
- Problem with Db2 Export Command
- matching criteris for a 10-digit number
- First iteration of stored procedure is slow.
- db2 procedure in solaris
- Alternate server for the db2 connect --fail over
- DB2 V9.5 FP2 release date
- Re: SQL 2008 published - Highlights
- Recursive SQL Question on breaking the infinite loop.
- Add a DB2 database partition in different drive
- Add a DB2 database partition in different drive
- Add a DB2 database partition in different drive
- settign DB2 environment under Windows without using db2cw.bat
- Need help on SP with GTT
- SOMET_09
- Re: Need help to canvert oracle funciton last in db2
- Difference between automatic and Auto-resize tablespace
- Maximum number of STRIPE SETS in a Tablespace
- DB2 EE LOADER
- Read Blob field
- Yellowfin seeks resellers for BI product
- Monitoring DB2 JVM
- robust optimisation
- OUTER UNION
- Storage required for VARCHAR in V9.5
- db2ckpwd uses a lot of memory
- Certification in Mind???
- Crash recovery for LUW on Linux
- Which are the best R&D websites for DB2 internals?
- HELP DESK SOFTWARE APPLICATION DESIGNED
- disable windows db2 user
- db2 udb crashed
- sql0954
- How to safely trim log space
- Midnight query chalenge
- Can I create unique index on selected records ?
- Urgent openings for Informatica with CMML @ PUNE, India...!
- Can I use "Get Snapshot" for DB2 on mainframe?
- Activate NIS authentication
- Problem While loading from Client Database
- Call to SP in partitioned env. not allowed
- DB2 Express-C on Vista/Business
- Looking for participants for a 30-minute DB2 survey
- Automatic maintenance policy files
- conversion from db2 to oracle
- Change value in IMPORT
- Query size limits
- Query size limits
- db2 username length 8 characters limit
- How does a SYSIBMADM created
- Is there a 'non-mandatory' relationship in DB2 8 for Z/OS?
- perl dbi built on DB2 8.2 does not run on 9.1
- Newbie question - this is highly unusal
- Purging task output
- DB2 UDB for z/OS V8 Sample Programs needed
- calling SP from UDF
- Paging steadily increasing over time
- MQT on a nickname
- PL/1 DB2 V8 Table Declaration for a CLOB
- PureXML
- trouble with C-written application and UDF on 64-bit Windows
- remove large number of rows using SQL only
- remove large number of rows
- Control Center problems
- max sequence value --- how?
- FETCH into sqlda structure
- Treatment of SMALLINT in Java Program
- cannot run db2imigr even if LIBPATH set
- SSL support for natvie DB2 LUW (non-SQLJ/JDBC)
- Preventing First Steps Launch Pad screen
- formula to calculate DB monitoring parameters
- Finding Tables without any Primary key
- What can we do about these non-topic postings to this group?
- What can we do about these non-topic postings to this group?
- Table in Load Pending state but Terminate command does not work
- spam
- HADR support for DPF partitions
- Why this Stores Procedure is not working - puzzled
- Not able to connect to db !
- Re: Rewrite LUW query to work on z/OS
- mon_heap_sz
- [Test]
- Why is DB2 not releasing memory sooner?
- Newbie on SQL & Excel
- Latest updates in database mangement and many more
- Re: How to check SQLCODE in trigger
- SQLOGDIR permissions in AIX
- spam
- spam
- TCPIP problem
- DB2 Express UDB 9 with db2jcc JDBC driver- Issues with Auto generatedfield
- Re: How to avoid 2nd trigger
- Any suggestion on how to speed up large batch inserts?
- Problem with IN predicate
- Re: ADVICE NEEDED: Removing Inner Tie Rod Ends - TWO QUESTIONS
- Special register USER
- db2exfmt and missing function EXPLAIN_FORMAT_STATS
- V9 runtime client setup problems
- overflowlogpath and hadr
- UDF Portability?
- What's the meaning of IID=0 in output of db2pd command
- User-defined aggregate functions and OLAP windowing
- about online reorg
- How to connect IBM DB2 with JSP?
- notify/listen?
- Tablespace qualifier in DB2 UDB On Linux/Unix/Windows
- backup falsely marked as in progress. can i clear this state?
- store procedure error
- How to LOAD deleimited data with linefeeds to mainframe DB2
- Re: SERGE I AM TRYING IPLEMENT YOU TRIGGER
- never-ending LOADs
- inserting data into a dependent table
- Redirect SELECT results to a file
- need help with the trigger
- DB2 patches - need historical record of proof
- Schema size(Size of all the tables in a schema)
- Latest updates in database management and SQL server
- brothers and sisters must register and send this article to users
- UDF RETURNS DIFFERENT TABLE
- DB2 8.2 Workgroup Server Edition limitattions
- SQL0101N The statement is too long or too complex. SQLSTATE=54001
- Timestamps on data records, Documentation on old versions of DB2
- privileges on functions
- Find a sentence with words separated by multiple spaces
- Re: Migrated From v7 => v9 ... and Now Can't Use Semi-Colons inStrings?
- library compatibility libdb2.so undefined reference to`__cxa_guard_acquire@CXXABI_1.2.1'
- Yellowfin Business Intelligence Release 4.0 Announced to Industry
- Temp tablespace - system or user?
- TRANSLATE function
- SMS TableSpace - Reorg not releasing space.
- Multiple fault monitors from different db2 versions
- Re: Delphi + Stored Procedure + Locks
- Export utility is taking long time
- Export utility is taking long time
- Export utility on a table is taking long time
- Runstats error
- Re: Community's water tower perhaps somewhat in questionable taste
- Re: Migrated From v7 => v9 ... and Now Can't Use Semi-Colons inStrings?
- Urgent - need help
- CREATE TRIGGER ON INSERT
- the option CPU_PARALLELISM of LOAD
- When does a stored procedure use an MQT
- Re: Question on syscat.keycoluse.colseq
- Getting group of data for each member of primary key
- FYI: IM Consumability Survey
- Parallel SQL (forking) in SQL stored procedures
- Question: restore from backup in relative path...
- Re: Otra vez sin news (news.tie.cl) ...
- converting DB2 triggers to Oracle
- error messages for key constraint violations
- z10 or z9
- Re: Questions to FAILARCHPATH and HADR
- MQ Functions included in DB2 Workgroup Edition?
- FYI: DB2 for LUW Best Practices
- Find the latest updates in database management of IBM
- CLOB and searching by it
- Reorgchk, Reorg, Runstats not having any effect after completion. Why is this?
- SQL to find if table has identity and/or row change timestamp columns
- DB2 9 runtime client install
- Estimating performance on an OLAP database (virtualization vs. serverinstall)
- How can I use shell script to remove specific records from a flat file?
- import XML file into DB2 table
- DB2v9.5 64-bit does not allow me to chose location of user tablespaces. Why?
- Trigger fire a query
- bind file recovery
- How to terminate idle agents?
- DB2 query hours difference
- Migrated From v7 => v9 ... and Now Can't Use Semi-Colons in Strings?
- Control Center SQL Assist
- How to get 'message text' portion of error from SP
- String comparison in DB2
- Getting rid of nuls
- Getting memory size for an application
- Catalog Service - User interrupt detected
- Is it possible to "enable" auto-rollback functionality whiledead-lock occurred on DB2/400?
- BACKUP & RUNSTATS running simultaneously
- db2 load using v9.1 client into a v8.1 fixpak 16 database
- CPU usage in DPF on Windows during massive parallel single rowinserts
- Loading Data from SYSCNTL and SYSREC files
- CTEs in UDFs
- Parameter markers in LIKE clause
- What is SQLCODE=-3196?
- Oracle Database Training, Practice Tests
- Need help w/.ksh script to REORCHK & output Recommended tables to a file
- How long does it take to migrate db from 8.2 to 9.1 on LUW
- Re: Takers for a Friday SQL puzzle? Timestamps and recursion...
- Re: Takers for a Friday SQL puzzle? Timestamps and recursion...
- How can I installed DB2TOP on my windows or Linux?
- Re: Takers for a Friday SQL puzzle? Timestamps and recursion...
- HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers ,
- Database Application Front End
- db2 client hang - db2osse!ossLockGetConflict
- Re: Olympialaisia terävänä
- How to get list of database?
- [z/os] Finding location of DB2 specific copybooks
- Redirected restore DMS -> SMS (or automatic storage) possible?
- Is it possible to develop ODBC program on AIX?
- how to develop embedded SQL program by C language?
- Lock waits during online backup
- Re: How to reset auto generated id in a DB2 table
- Is replication really transferring data via my desktop PC?
- How to reset auto generated id in a DB2 table
- DB2, vim, and dbext
- Ask for help from ORACLE board: matching normalized and denormalized tables
- DB2 'CASE' puzzle slqerr -811
- DB2 Performance Monitor.
- how to define such a trigger....
- Cross Platform db Restore
- Distributed statistics and optimizer
- Re: How to get stored procedure definition?
- How to get stored procedure definition?
- .databean.jdbclob from DB2 Control Center
- how to create Store procedures without using development center
- Can someone enlighten me on 'handles'?
- SMALLINT casting difference on Windows vs AIX
- Is there is a way in DB2 to return multiple fields from a single case
- DB2 9.5 fixpack 1 stalls when running script
- Re: perform date and time arithmetic, represent seconds and dates inDB2
- SQL-> RDF or other question about linked data? Win a pass toLinkedData Planet for best question.
- Update, case, and -407
- Can i drop a cloumn from a table in DB2 for Z/OS
- DB2 Intelligent Miner - for 64 bit AIX 5L
- Control Center - Activity Monitor Permissons?
- root owns files in db2 instance directory.
- Re: DB2 Query Help
- DROP PACKAGE with hex zeroes
- Performance Goals for DBAs
- Query from ORACLE board is not working in DB2
- stop remote instance
- stored procedure or SELECT statement
- monitoring backup
- SQL statement not supported error SQL1042N for MQT defn on a nickname
- Generate Unique Number in DGTT
- any warehouse database upgraded to v9.1? or v9.5?
- decimal to date
- Stored procedure, first run slow
- LDAP and caching on DB2 9.5
- loading in to generated row change timestamp column
- ADD A COLUMN IN SERTAIN POSITIONS:
- Reading Arabic data from db2 v8 using db2 wire protool
- DB2 UDB Installation on Windows Vista
- DB2 memory usage help
- ho w to see the output of "Message_Text"
- DB2 on z/OS different than on LUW ?
- move rows from one table to another
- Re: Long compilations
- Database Management
- Multitable insert in DB2 v8 os no Merge is avilable:
- Re: Long compilations
- Plug-In extension for Control Center
- How to fined un-unused indexes on DB2 /ZOS
- TRUNCATE stored procedure
- Get Diagnostics
- Multi-row insert timestamp error
- V9.5 and SQL1084C
- DB2 contoken split by PLI compiler
- Is this is output from EXPLAIN?
- Schema on Db2 database installed on Main frame machine zOS.
- How to calculate difference between 2 columns excluding nulls
- Re: SQL - Unexpected result
- collating sequence
- Re: SQL - Unexpected result
- problem: sum is incorrect (e-10)
- Rolling out V8 client using response file
- Re: DB2 equivalent for ORACLE SQL*Plus BREAK???
- Seeking simple after insert example
- Re: rollup for DB2 UDB for iSeries ?
- IDENTITY PK-FK corruption of data