Bytes > Sitemap > DB2 Database Answers

Pages : 1 [2] 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

551. How toI change this time duration 1.80 into this 2.20
552. How can i tell if restore is actually running?
553. Does PL/I work on DB2 v8?
554. Write a stored procedure with a table name as an argument to insert data into table
555. 'hash index' in DB2 V10.
556. Question with Automatic client reroute HADR
557. priviledges in db2
558. How to pass a shell variable to a .sql file
559. Why is the database size is larger than the server disk space?
560. How to Create table using like but with modifications?
561. How to concatenate 3 fields in a where statement see attach
562. Compare 2 identical tables script
563. on IMPORT SQL0437W Performance of this complex query may be sub-optimal
564. Server Crash - Application
565. Querry using Catalog information..
566. Tablespace design for range partitioning tables in DB2 LUW
567. Comparision of 2 identical tables
568. What type of query will return the correct results?
569. How to declare timestamp variable with default as current timestamp not working.
570. how can import data acces to db2 in development center
571. How to view a CLOB Output parameter returned from a procedure in DB2 control Center?
572. Slow running sql stored procedure
573. Hy everybody, i'm getting a error:
574. DB2 z/o query performance?
575. Sql0104n ... Sqlstate=42601
576. Union All causing headache
577. using dynamic SQL in a function
578. How to downgrade db2 9.5 to 8.2
579. I am interested in an answer to a RACF Group issue with an Authid
580. how to identify the all the dbpartitions up and running?
581. DB2 tablespace storage
582. how to get all table names from db2 database schema
583. how to restore Cognos 8 Sample DB2 tables
584. I need to expand a field in a db2 table, must I write a conversion program???
585. Use RID in DB2 z/OS V8.1 to find a row
586. Is there any recomendation on how much the underlying FS be free for DMS containers?
587. System: DB2 luw (unix) v9.5 fp4 - Q-Replication & inplace REORG
588. problem solved: error occurred while initializing the Profile Registry
589. z/OS DB2 Runstats Utility v8
590. i have error SQL Exception in DB2
591. DB2... stored procedures?
592. what is difference between dbms and rdbms?
593. A query on SELECT statement in DB2
594. executes cobol program calling another cobol db2 program
595. How to excecute a .sql file from db2cmd
596. Round off the sacle of decimals in db2
597. Can we move the spaces in the integer column.
598. How do I find the table dependency information for stored procedures in db2
599. Closing a .Net OleDB Reader is taking 250ms on DB2
600. Loading CSV file into DB2
601. db2 activate database results in 1226 - Overflow agent is not allowed
602. How to replace '0'
603. How to drop/find depencies of a user defined function in DB2?
604. Using recursive CTE in stored proc?
605. Having multiple databases in my environment...need to start stop every week
606. To start and stop multiple databases in db2
607. how can i select one row out of duplicates in a table.
608. DB2 Triggers
609. Problem in installation
610. Connecting servlet program with db2 gives an error
611. how to update/delete a row with DB2 within the same table
612. What about "match simple" instruction?
613. How to get column information from db logs
614. DB2 Query Patroller failed
615. does CTE use or create temp tablespace?
616. How do you join rar files?
617. Hello all, I am getting a syntax error (see below) while creating a stored
618. To import bulk data in databse in db2
619. When retrieving the data from DB2 through Excel do we need to catalog the databases
620. How to see the collected statistics on declared global temporary table ?
621. Can we truncate a table data using UDF?
622. Check-pending status in DB2
623. Having requirement to fetch record number 500 to 1000 from a table
624. does alter table add column affect performance
625. unable to create server for remote data source
626. How to solve a DB2 Mainframe database connectivity issue?
627. HADR- NEtwork failure server reboot
628. DB2 data from AIX to Windows
629. Calling a DB2 stored procedure from a trigger
630. DB2 upgrade 9.1 to 9.7
631. SQL1024N. A database connection does not exists. sqlstate08003
632. dsn1copy
633. What is the best practice for storing data in multiple time zones?
634. How to select a huge table in a readable format?
635. help required on IMPORT Command
636. How to prevent the insertion of duplicate entries in DB2 tables.
637. How to grant SYSADM privileges to user db2admin ?
638. Connect drupal-DB2
639. Error when trying to replace one sub-query
640. DB2 Bind Variables used in queries
641. is select statement considered as a transaction ?
642. How to change ? to -?
643. db2 :insert xml clolumn failed, HELP!
644. How to create db2 Database programmatically in vb.net
645. DB2 9.5 fix 4 - slow call of procedures ( SYSPROC.ADMIN_CMD, ADMIN_GET_MSGS ... )
646. Auto Update a table
647. Create DB2 Database When Application Runs First Time Development in Vb.net
648. db2 9.4 fix 4, delay between call of procedure inside of a procedure?
649. Inserts and deletes occasinally out of order when read using db2ReadLog API.
650. back up DB2 use TSM
651. DB2 Database Creation. At Application Startup Time
652. DB2 Database Creation. At Application Startup Time
653. How to kill a CICS thread after a online program Abend
654. database technique
655. DB2 Text Search, Update Index fails
656. [DB2] SQLWarning chain holds value that is not a SQLWarning
657. Temporary tablespace managed by database
658. Need to find when the customers next vehicle purchase occured in less than 1 yr
659. DB2 Client on Solaris fails to connect to DB2 Server on Linux
660. Creating function in Db2 (version 8) on mainframe
661. Concatenation in case of case expression
662. Troubles with 16 level nested stored procedure
663. db2audit command z/os db2 8.2
664. ALTOBJ (sql-stmt parameter size)
665. SQLERRMC empty on bind error
666. how to read exported files?
667. Data Base Replication Product and problem acessing data bases
668. How to create table in db2?
669. Sql storedprocedure return no error code
670. Error CPD3E34 DDM TCP/IP communications error occurred on recv() — MSG_PEEK
671. Code level Mismatch
672. DB2 UDB 9.5 FP2a is not using the best index
673. creation of 32 bit instance on 64 bit System DB2udb v9.5
674. Find DB2 job name from system tables in DB2 database
675. Using a Stored Procedure to Update data on AS400 DB2 database from VB.NET application
676. Returning max summarized amounts
677. Import specific colums
678. Attempting to simplify a complicated SQL statement with CASE expression
679. DB2 HADR creation get failed
680. Using returned results from a stored procedure
681. Manual bufferpool flush
682. Execute a DB2 command from JAVA.
683. Querry Execution time
684. Db2 stored procedure fetch multiple rows
685. Last Mon to Sun
686. Group / max
687. Split function in DB2 Version 5 Release 4
688. db2diag.log doesn't capture deadlock
689. Multiple condition trigger
690. Identifying through many columns
691. Wildcards in DB2 SQL
692. Java application against Oracle to DB2 migrated Databases
693. How can I find time/timestamp of instance creation on DB2 LUW?
694. DB2 via Clist
695. Db2 error SQL0901N SQLSTATE=58004 : Reason "Sdir len bad: 1542!=1520+14"
696. Query to Search Data
697. Error SQL0206N
698. Compare DB2 source db and target db after replication/HADR
699. Running Sql script from DB2CMD
700. Connecting to DB2 database on remote server (UNIX)
701. DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130 in db2diag.log
702. Migrating from AIX DB2 V.8.1 FP 13 to WINDOWS DB2 V8.1 FP 9
703. What are the pre-requisites to install IBM db2connect Version 9.5 FP2
704. db2move from DB2 AIX to Windows
705. How to pass a variable as a parameter to DB2 database from shell script
706. DB2 trigger error
707. snapshot_statement stmt_text unicode problem
708. DB2 9.7 High response time on 50 concurrent users
709. 32 to 64 bit in HADR env
710. Select only a portion of the resulting rows
711. DB2 Populate Date Dimension proc
712. substring command not taking $ symbol in string
713. Create db2 table directly by importing flat file without prior db2 table existing
714. Getting Error sql0338n
715. How to get the stored procedure information?
716. hw to get the stored procedure information?
717. Db2cmd error
718. MQT with MQT
719. Performance Problem with Order by Clause in DB2
720. BAckup online with include logs fails !!!
721. How to write a stored procedure?
722. locks, transactions and stored procedures
723. Return union result in one row?
724. SQL1336N and DB2 CONNECTIVITY PROBLEM. What am I doing wrong?
725. Journals in DB2 Server Edition???
726. Migrate DB2 database from Solaris to Red Hat Linux
727. How to calculate size of partition in DB2
728. MQT in DB2 V9.1
729. Problem in fetching procedure text
730. Problem with cursors
731. what is bufferpool in db2?
732. Urgent - DB2 Function
733. i am getting error of SQL0811N in db2 stored procedure. please help its urgent!!!
734. MERGE STATEMENT IN UDB vs z/OS
735. db2 user account deleted accidentally
736. Using LIKE to compare input to column
737. how to load a Db2 table from a compressed file which is an discarded output of REORG
738. error in Stored procedure while using cursor
739. A long string as a Input parameter in procedure
740. List of ALTER Commands which needs REORG to be issued
741. Improving a SQL statement
742. Data export from db2
743. How to connect db2 to java
744. Sort table names by foreign key dependencies in a schema/Database
745. From Oracle to db2 Federation - db2 "crash"
746. Problems querying tables in federated database
747. How to insert X rows into a table from a Select clause?
748. Difference in record counts
749. DB2 cast issue in UPDATE with parameter marker
750. -802 error for count(*) query for a DB2 table
751. Viewing the SQL behind a View in 9.5
752. Database exception while running a batch program on Db2 V8.
753. Which function has TOTAL equivalent to Oracle's TO_CHAR?
754. Connecting to DB2 v7.1 from .NET ?
755. Updating only the year in a date
756. Alter an index in DB2
757. Compare multiple result sets
758. How to connect from DB2 V7.1 to DB2 V9.5 ?
759. How can i store the value returned by sql statement in a variable.
760. Merging Two Triggers
761. How to have multiple statements in one query using iDB2Command in .Net
762. Migrating database from DB2 V8.1 to 8.2
763. db2 index reorg status monitoring
764. Db2 9.5 behaviour in Solaris 10
765. Questions with Archival logging for HADR Setup
766. Few Questions with HADR - 1
767. how to detect unavailable tables?
768. Fetch command in cursor is very slow....
769. Struggling with db2 and ASP app -- Calling a stored procedure
770. db2 v9.1 UDF in C, Windows platform
771. The command contains illegal characters or keywords (It does?)
772. Both my application and reorg is slow...
773. No one can answer this question
774. convert 'Apr 19 20:00:03 CDT 2009' string to date
775. Problem with Update Query in db2 9.5
776. Connecting to Mainframes DB using a .NET interface
777. Web Form to Database
778. Set Null Using Java
779. DB2 V9.5 Tablespace -pages missing and Total pg's not equal to useable pg's
780. db2move issue with as400 iSeries library
781. Incorrect "union all" results
782. 2 linked inserts in one statement
783. DB2 table design and performance considerations
784. Difference Between DB2 zOS and DB2 UDB
785. DB2 integer to Varchar autoconversion in Update
786. How to Transmission of Large data accros network?
787. Help required on using FILTER USING in CREATE FUNCTION
788. Loading tables from USS on Z/OS
789. DB2 on delete cascade is not working
790. Single Tablespace or Separate Tablespaces
791. retrieve all table names from DB2
792. Stored procedure, function, very dynamic SQL and casting
793. problem with db2 installation
794. Trigger Problem
795. Migrate db2 express to iseries
796. db2 cross platform restore
797. DB2 Join result columns are unnamed due to different column names used in subqueries
798. Calling a UDF
799. Row Locking
800. How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
801. help: a speech interface for information retrieval using a .db2 file
802. same fenced user for different instances with different versions of db2
803. Larger DB2 spaces
804. remove newline character from field in exported table
805. Syscat.triggers valid column
806. DB2 Cpu Usage
807. DB2 TableSpace Usage Actual Size vx Allocated Size
808. Asyncronously accesss data using JDBC from DB2 database
809. sending alerts to users
810. Get diagnostics
811. How to recovery a dropped table?
812. db2 upgrade to v8.2
813. DB2 AIX Admin tools ??
814. Is Replication center v8.1 compatible with DB2 v7 Z/OS ?
815. restore database
816. plz suggest reg. cursors
817. plz help- query related to DB2
818. Using a DB2 User Defined Function
819. makefile
820. Updating an indexed column with the same existing value
821. SQL0104 on Update with Fetch
822. Use of OLAP function
823. How do I change Instance in DB2
824. Catalog Local windows DB2 database on AIX machine
825. MS-SQL queries to DB2 conversion
826. Should system temporary tablespaces generally be on automaticstorage?
827. u just click u get some dollars
828. SQL0284N error
829. how can i generate a unique table name at runtime from db2?
830. How do I concatenate strings from a column into a single row in DB2
831. SQL0206N "O.$COID" is not valid in the context where it is used.
832. Online reorg & log full condition
833. SQL Doubt
834. Trigger: After Delete ... for each row behaviour
835. Views and union...
836. passing input paramter of type list
837. diag.log.sav
838. Can we create a sample database on the app dev client
839. Explain of update-statement without commit
840. What the problem with VARCHAR_FORMAT?!?!?!
841. Confused about memory parameters
842. DB2 triggers & Cascading deletes
843. JOIN between 2 tables. No foreign key, just ranges
844. Online backup locking out processes...........
845. UDB Stored Procedure
846. Prepared statement too long
847. Sustain Business with Regular Audits
848. DB2 and CIO DIO on AIX
849. Lock Table and auto commit
850. A blog to lift the fog on Dataphor
851. any documents for 32 bit and 64 bit stored procedure conversion ?
852. Re: SIGNAL ON DELETE AND CAPTURE
853. DB2 DBA required in Vancouver, BC (Contract)
854. Re: SIGNAL ON DELETE AND CAPTURE
855. Java or .NET interpreter startup or communication failed, reason code "2"
856. No access to the SNAPDYN_SQL view
857. Stored procedure Slo
858. How to "LOAD COPY NO" without backup ?
859. DB2 PHP connection issue
860. Query doing table scan when added simple predicates
861. new dba blog
862. Is this an Invalid option? | db2pd -apinfo
863. parallel insertion into a table in DB2
864. NOT ENFORCED RI - what optimization opportunities are missed?
865. DB2 Career
866. SQL0746N: Routine violated nested SQL statement rules when attemptingto perform operation "MODIFY" on table
867. Stored Procedure has no access on a remote file
868. Please review this Explain plan output - need help
869. Uniqueness checking overhead
870. setting optimization level in stored procedure
871. SQL Error
872. db2diag -g db=DBNAME,instance=instname
873. FLUSH PACKAGE CACHE DYNAMIC
874. Load performance on AIX w/ SAN
875. Last access time for index
876. SQL30081N error
877. Multiple databases in one project
878. dsn1copy uses dynamic allocation for multiple pieces
879. Error using old table() in UDF
880. Unable to restore DB2 Database on Linux
881. "WITH RS USE AND KEEP UPDATE LOCKS" An unexpected token
882. 64 bit encoding in CLOB
883. Problems with a simple Trigger :-(
884. sqlqgRouter_conn_lost_cleanup in db2diag.log
885. How can i modify the following query in DB2
886. Linux + DB2 + php
887. Co-releated Update Statement Tuning
888. Overriding database collation in queries for LIKE operators
889. Find SQL in Stored Procedures
890. Getting rid of kuddb2
891. IBMLDAPauthserver/IBMLDAPgroups, DB2 v. 9.5 ppc-Linux
892. Database creation failing on AIX.
893. Migrate schedules from one instance to another in V9.5
894. runaway sqls
895. DBA question on locating partition to which a specific tablespace page exists
896. SQL PROCEDURE on the iSeries
897. DB2 - forcing a table to cache all data in the buffer pool.
898. What is the syntax for finding the Month(number) in DB2?
899. DB2_USE_ALTERNATE_PAGE_CLEANING and HADR
900. db2 doesn't start on windows2003(update from win2000)
901. After adding a tablespace container: DMS rebalancer is active
902. More DB2 Vista NewBee questions
903. Beginner help needed - error connecting DB2-9.1 with RAD7.0
904. HADR - AIX
905. NewBee Express-C Questions
906. How to debug sqc program
907. Backup with include logs option
908. encoding schema in pcap file
909. Assume a bookshop has database with the following
910. Capacity of "Trial"
911. call a SQL Server 2000 stored procedure from DB2
912. Multibyte data passed from OMVS to DB2 stored procedure gets corrupted.
913. Problem with calculate difference between rows
914. capturing optimization level used for certain sql
915. How to get database size in DB2?
916. index usage?
917. DB2 instances in SDLC
918. Troubles with Start database manager
919. Optimal Method for Getting Max Value
920. Dynamic From Clause To Create View
921. PCML and DEXA
922. Max table or database size?
923. db2 questions
924. V9.5 HADR On AIX
925. how to run a COBOL-IMS-DB2 program
926. stored procedures dependencies
927. Query for selecting NON DUPLICATE ELEMENTS in a table
928. difference in performance in two environments for same sql
929. Re: SQL0104N An unexpected token error
930. difference in performance in two environments for same sql
931. Replication Connect Error
932. DB21034E with triggers
933. dynamic sql - prepare statement
934. db2fmd - instance crash
935. Diff in DB2 versions
936. Unique values in column
937. Update using WITH statement
938. SQL1042C An unexpected system error occurred. SQLSTATE=58004
939. Unicode arguments in posstr(), locate() and LIKE
940. Restore Questions (32 vs 64 bit)
941. DB2 federation problem when reconnecting to a remote federated AS/400
942. How is DB2 tables stored?
943. regarding cics
944. db2stop taking time
945. Merge on LUW 9.5.1 - Not Atomic Continue on SQL Exception
946. Restrictions for SSL on db2 express c luw?
947. DB2 Database Administrator
948. DATABASECAPACITY and SMS tablespaces
949. stored procedure to drop tables
950. Health Monitor Invalid history version in header
951. What happens after new function mode
952. java torque nullable columns
953. Possible to manually mark routine packages as inoperative in DB2LUW?
954. adding nullable columns through torque
955. DataServices World features Universal Services, SOA, WOA and cloudcomputing (San Jose, November 20, 2008)
956. SQL3255 on DB2 v9.1 Win32 with db2move
957. java torque save method exception
958. issue on
959. 9.5 LUW, pointers on running 32 bit client against 64 bit server?
960. Question on SQL-based Administrative Task Scheduler
961. Yielding timeslice
962. db2 stored procedure
963. Get the last day of previous business quarter
964. NO FILE SYSTEM CACHING - Automatic?
965. Sigh, Undocumented error - SQL30082N, RC=22
966. Health Monitor - Manual Backup required...why?
967. confusion about cardinality in explain plan node on compressed table
968. confusion about cardinality in explain plan node on compressed table
969. Procedure performance vs Query
970. Re: MDC vs. cluster index: which to use?
971. backup with multiple targets
972. Add a partition to a table that already has partitions
973. Supress SQL0347 (CTE may contain infite loop)
974. update from select
975. SQL30082N Attempt to establish connection failed with security reason"24" ("USERNAME AND/OR PASSWORD INVALID").
976. Set Encryption password and SQL20143N
977. Yellowfin Enhances Business Intelligence Reporting forTelecommunications
978. CTE is not supported by db2advis
979. PHP5 and DB2 9.5
980. Db2 bind issue
981. query help
982. Detected the death of an EDU. Process was 11.
983. reset monitor switches while capturing snapshots with sql functionsor views
984. DB2 and Websphere MQ transaction coordination
985. db2 database pages
986. Solaris 10 Database bufferpool problem
987. sybase post
988. How to determine the isolation level of incoming queries.
989. Unique Opportunity To Join The Elite Group Of Project ManagementProfessionals
990. Select with odbc_exec (php)
991. calling stored procedure from Perl code
992. Syntax error when creating user mapping in DB2 (Data Federation)
993. actual/estimated cost/cardinality of query plan
994. progress bar for runstat?
995. DDF Security?
996. All about memory
997. HADR Status
998. DB2 low CPU low IO (low insert,low update) why ?
999. DB2advis error
1000. please help
1001. truncate tables in stored procs?
1002. How to Give Operating System Security in db2 if not configured duringinstall ?
1003. How to view the special registers in db2
1004. DB2 V8 String Parsing Question
1005. Migration from SYbase to UDB database
1006. Query execution
1007. lfd length & pd length
1008. Block Comment Confusion ...
1009. DB2 - check if product installed on Solaris/AIX/HPUX
1010. DSNL013I & DDF, DB2 9.1
1011. DB2 9.5 SQL Procedure Developer exam 735 prep, Part 2: DB2 SQL Procedures
1012. Connect to Windows DB2 server from unix
1013. DB2 problem, need help
1014. REORG INPLACE -964 ERROR
1015. INPLACE REORG problem
1016. Kernel parameters for db2 v8.2 on Solaris 10
1017. DB2 Client Upgrade Questions ....
1018. HAVING and WHERE clauses: Performance considerations in SQL
1019. how to find middle row of a table?
1020. SQL help
1021. Try ... Catch
1022. Newbie - Partition setup multiple tables
1023. received this error message DB21034E running an ALTER Stmt
1024. Last DB2 to run on Solaris 8
1025. LOAD with COPY
1026. query to retrieve middle row of a table
1027. Difference between byte[] and blob
1028. Advs & disadvs of Self Tuning Memory Management feature of DB2 v9.5
1029. To Execute DB2 commands on AIX with a user other than instance.
1030. Collecting DB2 performance results for my thesis paper
1031. Selecting from a Dynamic Table in SQL
1032. Just checking
1033. Dynamic sql statement called in a stored procedure SP
1034. Please explain query intervals output
1035. On-line file backups
1036. Variables in SQL???
1037. outer join table filtering
1038. Row_number() over() not working in SPUFI
1039. SqlException Unsupported ccsid, encoding, or locale: "Cp037"
1040. why is NULLID.SYSSH200 executing so many times
1041. Leading Zeros
1042. DB2LOOK Privileges
1043. multiple databases in one instance
1044. ******GOD OF GIFTS 4 U*********
1045. IF Exists Bad Parser
1046. Re: Include all columns in an unique index
1047. shell script to extract rows from table
1048. Re: DB2 Container behaviour on EMC DMX 3 San.
1049. using setAutoCommit(false) in DB2 and MSSQL
1050. db2 V9.5 SQL1084C
1051. Re: Include all columns in an unique index
1052. Why is my static SQL dramatically faster than dynamic?
1053. IXF Column Descriptor Record
1054. Re: Include all columns in an unique index
1055. Db2 v9.5 - Undefined Symbol while creating an instance
1056. Merge statement: Index on source table
1057. DASCRT Command failed.
1058. Multiplexed Connection
1059. Re: flush package cache dynamic executed from client.
1060. Self tuning bufferpool
1061. Self tuning bufferpool
1062. regarding RAM size and db parameter
1063. Empty Table
1064. Help with query on sparse timeseries data
1065. Net Search Extender Throws Confusing Error
1066. Prepare Statement in DB2
1067. Ondemand
1068. Dropping indexes on a partitioned table
1069. Rows in a DB2 table..
1070. Requirement - Database Architect - State of Oregon - 6 months
1071. Merge Into using 'With UR'
1072. IBatis DB2
1073. DB2 error in DB2 control center
1074. Changing the DB2 Interface Language under Windows
1075. Does V8 of DB2 zOS supports
1076. db2 tablespace restore
1077. db2 table space restore
1078. Interview Type Question
1079. Time related question (Subtime)
1080. Mass Updation of Records
1081. Rows in IXF file
1082. Need example for accessing Resultsets from COBOL DB2 Stored procedures from Java
1083. Deletion from a large table (with two child tables) takes more than an hour
1084. Yellowfin says Java the smart option for Business Intelligence
1085. Clob variables in stored procedures and SQL10003C
1086. Question Regarding Parameters for DB2 COBOL Stored Procedure
1087. Using load/import with global temporary tables
1088. how to force bind option for JDBC in db2?
1089. DB2 equivalent to this Sybase syntax
1090. DB2 Bulk Load via Java/JDBC
1091. Db2 Explain weird results
1092. Call for speakers for DataServices World in Silicon Valley closes September 26, 2008
1093. REORG REPLICATED TABLE
1094. retrieving information from 2 tables
1095. blob and clob
1096. MQT cannot be used for queries with parameter markers?
1097. Project Management 2.0 !
1098. Clob
1099. Primary Key error wrong number of qualifiers
1100. DB2 9.5 equivilent of alternate fixpack